Before function in line chart

[Anonymous]

@hi,

I am trying to create expression using 2 dimensions in line chart.

For Example my 2 dimenions are MonthYear ,code

I want current month sales for the below data,consider A,B,C as number of sales and table below is the result table after calculating the sales of (current month)/(Previous month and Previous code). I achieved this in  pivot table expression

sum(Sales)/above(before(sum(Sales)))   but I need this in Line chart.

Please help me with this.

Thanks in advance.

[sunny_talwar]

Try this in your chart

Sum(Sales)/Aggr(Above(Aggr(Above(Sum(Sales)), MonthYear, code), code, MonthYear)

[sunny_talwar]

See an example here

Need Help to create roll rate line chart from above and before function