Question on Chart Expression

[ramanarayan]

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.

I need help with the expression 2 please.

Appreciate your help.

[sunny_talwar · Accepted solution]

Try this expression for line

=RangeSum(Below(Sum([Sales Units]), 0, 12))

[ramanarayan]

Thank you Sunny for the quick turn around. Very much appreciated

[ramanarayan]

stalwar1‌

HI Sunny,

I have one additional requirement on this topic here.

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.

Attached is the qvw.

Appreciate it

[big_dreams]

Open new thread, so other people will also help you..

Regards,