Month on Month analysis

[srinivasa1]

Hi  

Can any guide me how i can do Month on Month analysis

I would like to do calculation for  sales diffrence Year 2011,2012,2013 ie :if selected FMonth filter Jan,Feb,Mar 

  My sales difference will be  like (2012_jan -  2011_Jan )  and 2013_Jan-2012_Jan Have attached qvw

Highly appreciating any help

[phaneendra_kunc]

Use following...

Dimensions: Product, Fmonth

Expressions:

=sum({<FYear={'$(=Max(FYear))'}>}Sales) - sum({<FYear={'$(=Max(FYear) - 1)'}>}Sales)             // For 2013-2012

=sum({<FYear={'$(=Max(FYear)-1)'}>}Sales) - sum({<FYear={'$(=Max(FYear) - 2)'}>}Sales)          // For 2012 - 2011

See attached...

[srinivasa1]

Thanks It helped me lot

Thanks

[srinivasa1]

Hi

Some issue i found in that .if start selection from Jan to Mar then mar 2013--2012 clos also displaying and if selecting from feb onwoards my year will become 2011-2010 data. there is no data for 2010.still its displayinf it should be 2012-2011 only.can you pls guide on same

[phaneendra_kunc]

See attached..