Hi Experts,
stalwar1
I have a combo chart with 2 expression.
Expression- 1:- Sum of Sales Units
Expression -2:- Sum of Sales Units from the current month to rolling 12 months. For eg; For Jan'18, sales units is 10 units which is represented in the bar. For the same month Jan'18, the line graph should show total sales units as 2902 units (which is the sum from Jan'18 to Dec'18). For Feb the expression 2 should show from Feb'18 to Jan'18 which would be 3125 units and so on.
The trend line should always be static for 12 months and should not change regardless of selection in month which I will have as a saperate list box.
For eg- The current trend line does the sum of sales for 12 months when there are no filters applied. If I want to view just 4 months of data the trend line should still show the same 12 months sum and not change for just 4 months.
I need help with the expression 2 please.
Appreciate your help.
