today I would like to create a bar chart with the following look:
I have three KPIs (NSR, GSR, Fundings) for each year which should be displayed next to each other. The following "connection" exists between the different KPIs:
NSR = GSR - Fundings
I attached a screenshot (made with Think Cell) which shows the result I would like to achieve.
First Row: GSR
Second Row: Fundings, starting from the GSR value and going down to the x-axis
you can work this by using the waterfall model where you can create an expression in the bar offset for each expression rather than the plan expression