Divide DataX(Month) by DataY(Previous Month) in a Monthly Line chart

[bertrand01]

Hi everybody,

I have to make a Monthly Line chart. 
Basically,  I want to divide DataX(Month) by DataY(Previous Month) in a Monthly Line chart. 

I have tried this kind of set analysis : 

=Date={"=AddMonths(Date,-1)

But I get the same value as the current month ?

Any idea what I can try ? I would not like to make this in the load script.

[Kashyap_R]

Hi

Try this

Current

Sum({<[Date]={">=$(=MonthStart(max([Date])))<=$(=Date(Max([Date])))"}>}Value)

Previous

Sum({<[Date]={">=$(=MonthStart(Addmonths(max([Date]),-1)))<=$(=(Addmonths(max([Date]),-1)))"}>}Value)

Thanks

[bertrand01]

Thanks, but this can only work for max month, not for every month as it is based on the max date.
I want it to work in a line chart for every month, month being the X axis.

[Kashyap_R]

hi

try this 

Sum(Value)

/

Above(Sum(Value))

Sort according to month

Thanks