Top 4 values in a column

[Former Member]

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.

[former_member198519 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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.