3 Replies Latest reply on Apr 7, 2016 9:05 AM by Bas Groothedde

    How to calculate custom Totals for Top N (Percentage of total)?

    Samarth pp

      Hi,

       

      I'm trying to calculate the total for TOP 3 segments which has percentage of totals. If I use Column Totals it always gives 100%. The requirement is to show only sum for the top 3 (please see image below)

       

      is there any workaround to do this? Tried with different formals (fixed;Window_SUM etc), it works for totals but don't work for percentages? please help.

       

       

      Message was edited by: Samarth pp Hi All...firstly, thanks for responding.  I have attached the twbx file. I need to show only the total % for top 3 not 100%. Please help.