3 Replies Latest reply on Oct 21, 2016 6:46 AM by Ben Young

    Calculate % of total with a top 10 filter

    Richard Sanchez

      Hi all,

       

      I'm trying to get a simple text table where I have totals per category, per product per country and I want a second measure column where the % of total is shown. Of course this is simple BUT if i use a top 10 filter the % of total calculation is done on those top 10 rows instead of all rows. Is there a trick to fix this? Currently I've created a RANK on the totals and hide everything except the top 10. Is there a better way?

       

      Thank you,

      Richard