How to show Group Total as # while Bars are shown as %?
I have a card right now using a Nested Bar Graph and I'm showing the series bars as % using the Data Label Settings as '%_PERCENT_OF_CATEGORY' but when I check the 'Group Totals' box it shows the total as a 100%, which is pretty useless to me because I want to see the actual count.
How can I do this? I thought about changing each series into it's own percentage calculation but that changes the entire scale into percentages and would also not show what for the Group Totals. Also, that is very tedious to make new beast modes for each series.
Is there a way to show Group Total as count and the series as %?