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
Listing only unique values
Re: Listing only unique values
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.
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.
- Attachments
-
- Report.mrt
- (17.19 KiB) Downloaded 960 times