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

# Custom Grand Total for Top N (Percentage of totals)

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.

• ###### 1. Re: Custom Grand Total for Top N (Percentage of totals)

Hey Samarth,

I have a feeling that you won't be able to accomplish what you want using the Grand Total buttons. Instead, you'll likely want a table down calculation or a calculated field. If you're unable to figure it out, please attach a packaged workbook with sample data and we can try to help.

-Diego

• ###### 2. Re: Custom Grand Total for Top N (Percentage of totals)

Hi Deigo,

Thanks for the response. I have tried calculated fields earlier. But it did not work (sum of percentages is always 100%).

• ###### 3. Re: Custom Grand Total for Top N (Percentage of totals)

Hi Samarth,

Grand totals can be a little tricky. We need to do two things to fix this issue: 1) Replace the RANK() field used as a filter with a computed Top N set, and 2) replace the quick table calculation with a level of detail (LOD) calculation. In the example workbook, you were using a percent of total calculation, which I replaced with:

{ FIXED [Bi Segment Name] : SUM([Moving Sum of TOTAL LEAD])}

/

{ FIXED : SUM([Moving Sum of TOTAL LEAD])}

I have applied the fix in the attached workbook. I hope this answers your question!

1 of 1 people found this helpful
• ###### 4. Re: Custom Grand Total for Top N (Percentage of totals)

Hi Samarth,

Please find the attached Percentage of totals workbook.

Thanks and regards,

Rohan Malusare.

1 of 1 people found this helpful
• ###### 5. Re: Custom Grand Total for Top N (Percentage of totals)

Yet another alternative using table calculations only and a parametric Top N:

1 of 1 people found this helpful
• ###### 6. Re: Custom Grand Total for Top N (Percentage of totals)

awesome, thanks so much for the help!

• ###### 7. Re: Custom Grand Total for Top N (Percentage of totals)

Wow, you made it so simple. Thanks a ton!!!

• ###### 8. Re: Custom Grand Total for Top N (Percentage of totals)

Great, Thanks!!!