10 Replies Latest reply: Apr 16, 2015 3:25 AM by Amit Saini RSS

    Limit Top 10 by Expression

    James Kerrigan

      Hey guys,

       

      My problem is that I have a table with 4 measures and I want to limit the table to the top 10 based on the expression in the 3rd column (Increase #) while leaving that column in that place for presentation purposes.

       

      Right now it looks like this:

      helpchart1.png

       

      When I limit by top 10 it limits by measure 'Before 2014/15' when I want it to limit by 'Increase #'.

      Capture.PNG

       

      I get this to work by moving the 'Increase #' measure over to the furthest left, but I want it to stay in its column position in the above 2 pictures for presentation purposes.

      Capture2.PNG

       

      I also wanted to limit to top 10 a bar chart with the same expression that 'Increase #' has without actually having that measure in the bar chart.

       

      Is there any way this can be achieved?