Hello,
I'm looking for a way to show a percentage value (Avt vs budget) and the year to month value of the same calculation in 2 lines on one graph.
=(SUM({<[Date Year]={$(Dash_SelYear)} >} [TsDayTotal Tickets])-SUM({<[Date Year]={$(Dash_SelYear)} >} [TsForecast Tickets]))/SUM({<[Date Year]={$(Dash_SelYear)} >} [TsForecast Tickets])
This goes over the month dimension.
Totalizing the percentages resuls of course in a wrong value.