I got a variable or an expression that calculates the balance amount for a category of accounts up to a selected month as follows:
sum({<DBCR={'D'},Cat_3_Name=Cat_3_Name-{"Cash and Banks","Banks' overdrafts and short term loans"},Year ={$(=max(Year))},MonthNum ={"<=$(=max(MonthNum)) "},Month=>} MontLC2 * Multiplier)
-
sum({<DBCR={'C'},Cat_3_Name=Cat_3_Name-{"Cash and Banks","Banks' overdrafts and short term loans"},Year ={$(=max(Year))},MonthNum ={"<=$(=max(MonthNum)) "},Month=>} MontLC2 * Multiplier)
Now I want to show the variation of the value of the above expression per month on a line chart;
I put the above expression in this chart whose Dimension is Month from the calendar
However this expression doesn't return the desired results
