I think I have an answer for you in the attached workbook. Instead of computing the percent of total as a table calculation, I created a calculated field for it using an LOD calc. Then you can sort your 'BI Segment Name' by that field, instead of using the 'Calculation1' rank. I then filtered 'BI Segment Name' to just the top 3 by my new calculated field, and added the grand total.
Hope this works for you!
Percentage of totals.twbx 17.4 KB
Please find the attached wb.
Hope it could help.
To understand a logic behind, please refer to
the foundation article by Jonathan Drummey:
Jonathan, I found myself to refer to
the above gem of yours way too often :-)
Percentage of totals_YF.twbx 29.7 KB