The purpose is to get a better visual representation of how the bars have changed over time.
You could say the Pie chart achieves what I want (percentages of a whole) but I cannot get the visual comparison side by side. With multiple pies you can get the comparison over time but not as cleanly as this.
Any ideas on how to achieve 100% stacked bar chart?
I think the only way to solve this is to make a couple of helper fields in the financial rows database, which allows each entry to ‘know’ the total value of all entries in that month.
Then you can just divide by this amount in the reports.