Get the most occured string

Сonversation on different topics
Post Reply
Piku7
Posts: 1
Joined: Mon Mar 23, 2020 4:42 pm

Get the most occured string

Post by Piku7 »

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.
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: Get the most occured string

Post by Lech Kulikowski »

Hello,

You can use Grouping with Condition. Please check the sample report in the attachment.

Thank you.
Attachments
TopGroup.mrt
(791.52 KiB) Downloaded 330 times
Post Reply