add the grand total again.
right click and select Quick Table Calculation > Percent of Total.
Let me know if this works for you.
Robb – I don’t get the option for “Quick Table Calculation” …I got the grand totals by selecting “Analysis” then “Totals” then “Show Row Grand Totals”
OK. It's difficult to tell how the current viz was created without a packaged workbook attached
That said ...
I only know of 2 ways to do this...
1. Create the % of row and column workbooks separately and float them on the dashboard (like the attached)
2. Materialize all of your columns instead of grouping
Flav1: if [SomeCol] = 'Flav1' then [measure] else 0 end
Flav2: if [SomeCol] = 'Flav2' then [measure] else 0 end
Row Grand Total: sum([measure])
Pct of Row: sum([measure]) //(Using table calc for % of total)
Maybe someone else knows a better way...
Pct of Col_Row.twbx 440.8 KB
Let me make the workbook generic & I’ll send it for your review.