1 Reply Latest reply on May 30, 2012 10:35 AM by Tracy Rodgers

    show top 5 numbers

      Hi, I have a report with one dimension and 2 measures showing Sales 2012 and 2011 by store. I need to show the top 5 stores with the highest sales in 2012. How can I filter to show the top 5 highest numbers in one measure please?


        • 1. Re: show top 5 numbers
          Tracy Rodgers

          Hi Katia,


          There are a couple of ways to do this. The easiest would be to place the dimension on the filter shelf and choose the 'Top' tab. Then, choose by field, and choose the desired measure.


          Another option is to create a calculated field similar to the following:




          Then, place this on the filter shelf and select True. It may be necessary to right click on the calculation and change the way the calculation is computed (Compute Using).


          Hope this helps!