- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Month on Month analysis
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks It helped me lot
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See attached..