Hello,

I current have something like this:

Agency                         Prod
#       Agency Name       Type
73    Insurance Group       BP
73    Insurance Group       LL
73    Insurance Group       UL
73    Insurance Group       WC

What I want to have happen here is have the 73 and insurance group supressed so only one of each is showing. I am currently grouping this by Agency # and Prod Type. So the final output should be:

Agency                          Prod
#       Agency Name       Type
73    Insurance Group       BP
                                       LL
                                       UL
                                       WC


I'm assuming what should be done is supressing if duplicated but this does not work. I believe I need a formula to go along with it.

Edited by rkohs - 04 Jan 2013 at 4:07am

Thank you! Grouping by agency name worked!