cancel
Showing results for 
Search instead for 
Did you mean: 

Top 4 values in a column

Former Member
0 Kudos

Hello, This forum has been really helpful for me so far so hoping someone can help me with this..

I am trying to find the top 4 Categories from the Category column in the attached snapshot. Basically i am trying to find the 4 most common occurring issues for a report.

Accepted Solutions (1)

Accepted Solutions (1)

former_member198519
Active Contributor
0 Kudos

You can make use of Rank() in webi for displaying top 4 category but for that you need to have a measure value.

Try something like below and sort it in descending order:

=Sum(Count([Category])) In ([Category])

Former Member
0 Kudos

I get the number of different categories by using

=Sum(Count([Category])) In ([Category])


How do i get the name of category and how many times it occurs in the column.


Thx-Amit.

former_member198519
Active Contributor
0 Kudos

create a new col next to category and place this code in the new col. when you sort the count in descending order, category will also get sorted and you can see the name of the categories.

Former Member
0 Kudos

That did the trick and i am able to see the categories. Is there any way to remove duplicates from the category column. Similar to excel where you can remove duplicates.

Answers (0)