3 Month Volume Loss

[anikkumarhole]

Hi Dear Friends i Need Help on Below scenario ,

1) For 3 Months Volume Loss 

where in we have Dimension: Month and Measure: Sum(Qty) per Dealer  we want to see month on month Volume loss per Dealer.

Suppose in

In May=if(May Qty>0  and (Jun+Jul+ Aug) Qty=0 the  Sum(Qty)
In Jun=if(Jun Qty>0  and (Jul+Aug+ Sep) Qty=0 the  Sum(Qty) and so on

[Anil_Babu_Samineni]

In May=if(May Qty>0  and (Jun+Jul+ Aug) Qty=0 the  Sum(Qty)

In Jun=if(Jun Qty>0  and (Jul+Aug+ Sep) Qty=0 the  Sum(Qty) and so on

Try this?

If(Sum({<Month = {'Vol_May'}>}Qty)>0 and Sum({<Month = {'Vol_Jun','Vol_Jul','Vol_Aug'}>}Qty)=0, Sum(Qty)) as MayQuantity,

If(Sum({<Month = {'Vol_Jun'}>}Qty)>0 and Sum({<Month = {'Vol_Jul','Vol_Aug','Vol_Sep'}>}Qty)=0, Sum(Qty))

as JunQunatity,

.......

[anikkumarhole]

I want to show in charts it's should be dynamic. Monthyear on monthyear

Thanks & Regards,

Anik Hole