Page 1 of 1

Listing only unique values

Posted: Thu Oct 04, 2012 9:27 pm
by Henkster
I am trying to make a list of only the unique values form a long list of several values (text and numbers) for a summary. I tried to use the sumdistinct function, but that does not work with text values. How can I create such a summarized list? see example below

complete list:
car
bike
car
car
car
bike
bike
bike

The result I look for:
car
bike

greetings

Henk

Re: Listing only unique values

Posted: Fri Oct 05, 2012 6:10 am
by HighAley
Hello.

Try to add the Group Header with your field in your condition and put a text box on this group header.
Please, look at the attached report template.

Thank you.