2 Replies Latest reply on Jul 18, 2012 10:35 AM by clement.luton

    Dynamic Top N - N being the result of a calculated field

      Hello everyone,

       

      I have the following report sorted by amount:

      Column1- Merchant Name

      Column2- Amount for one period

       

      I want to display only the first 10%. So If I have 200 merchant for one period, I want to display the first 20 by amount descending.

       

      I know how to do a top 10, or even using a parameter to allow the user to select N but not how to do it dynamically by using a calculated field.

      Any idea ?

       

      I have a second question:

      I would like to add the following column

      Column3- Total nb of merchant for the period. So even tableau is showing the first 20  I would like to display on the 3rd column 200.

       

      Thanks for your help....