8 Replies Latest reply on May 4, 2016 7:09 AM by Samarth pp

    Custom Grand Total for Top N (Percentage of totals)

    Samarth pp

      Hi ,


      I need help to calculate the grand total of percentages which are derived from table calculations. when column level grand total is selected it always shows 100%; but I need only the SUM of top 3 totals.  Tried using different formulas, It works for SUM but wont wont for % of grand totals (always showing as 100%).


      In the below example they just wanted to see the totals for the top 3 as pointed by arrow; is there any workaround? Please help.