9 Replies Latest reply on Apr 6, 2017 11:39 PM by Norbert Maijoor

    using percenatge of total

    sarvesh chandra

      Have a data set where I have used rank to display the top 10 items.

      Sheet 1 is the complete data set.

      Sheet 2 have used the rank function to display the top 10 .

      Sheet 3 have used table calculation to calulate the percent of total. but it is caluclating the percentage taking grand total for the whole table.

      I want to calulate the percenatge of total only using the total for these top 10 items and not the whole table(grand total)

      i.e percenatge of total amongst these displayed top 10 items.

      Using top n filters solves this but dont want to use that as top n filters only shows the top 10 data and ignores the rest , if the data is repeated ie.

      if dat is 10 9 8 7 6 5 4 3 2 1 1 , top 10 will only display 10 9  8 7 6 5 4 3 2 1 and ignore the last 1 , but rank_modified displays them all.