Forum Discussion

joschultz's avatar
joschultz
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Top 15 in a report

What is the easiest way to show just the top 15 items in a report?  Example is I want to show the top 15 products in sales for the day.  I will have hundreds of products in the data but only want the...
Need Help
  • kcantor's avatar
    kcantor
    10 years ago

    I use the Rank X measure for my products in the filter area of the visual (or whole page as needed). Then, when I add other values, there is nothing to break. I don't put the Rank X in the visual, I just use it as a filter for the page/report. In fact, I usually fill in all other information then apply it last to pull up my top 25.

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

without CALCULATE the filter context for each row is always the same - all items have the same rank 1 this way

 

CALCULATE performs the context transition for each row of the table

sallen's avatar
sallen
Frequent Visitor
10 years ago

Thanks Sean. So effectively, without CALCULATE the measure is looking at each row individually, and ranking it #1. Where calculate forces the measure to look at the whole data set?