Hi All,
I'm new to this forum, but I'm not totally green in reporting (I hope ).
I have a question. Imagine that I have a field in database where material names are stored. Example:
MATERIAL
Rubber
Steel
Steel
Wood
Rubber
Glass
Rubber
In the report header I would like to get a name of material that occurs the most times in that column.
Thank You in advance for Your help.
Get the most occured string
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: Get the most occured string
Hello,
You can use Grouping with Condition. Please check the sample report in the attachment.
Thank you.
You can use Grouping with Condition. Please check the sample report in the attachment.
Thank you.
- Attachments
-
- TopGroup.mrt
- (791.52 KiB) Downloaded 343 times