Aggregation of "percentages of total" and "percentages of sub-totals"
I am looking to create a table as the following displaying revenue values and their percentage-distribution across all categories for:
a) each month
b) for the yearly total
If in any way possible, this should also work then for sub-totals:
(i) In the upper table the percentage add up to 100% on the sub-total row. I would also be happy having each of the sub-total tables as separate sections.
(ii) In the lower table, on the other hand, the percentages add up to 100% in the grand total row.
You'll notice that also the yearly totals amount to 100% on the respective levels (i.e. sub-totals or grand totals) - it sums each category across all months of the year, and then calculates the %-distribution of each category in the yearly totals.
So far I have only been able to get a yearly total which will have e.g. 1200%, i.e. summing up the percentages of each month in the yearly total, which IMHO doesn't really make any sense (at least I haven't found a use case where this logic would render valuable insight).
I've also looked at Nathan's awesome plugin featured under https://community.yellowfinbi.com/topic/percentage-of-sub-total which will get me some way towards the upper table, however, the yearly totals are something I can't yet figure out how to accomplish.
How can I achieve this ?
Thank you & Best Regards