Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to compare a set of month with the same set of month -1.
ie. if I highlight the months Jan2014-Feb2014-March 2014, I would like to have a column next to the previous where I have the sales value of Dec2013-Jan2014-Feb2014.
Year | |||||||||||
2011 | 2012 | 2013 | 2014 | ||||||||
months | |||||||||||
jan | feb | mar | apr | may | jun | jul | ago | sep | oct | nov | dec |
sales | ||||||
jan '14 | feb '14 | mar '14 | dec '13 | jan '14 | feb '14 | |
client | ||||||
client | ||||||
client | ||||||
client | ||||||
client | ||||||
client |
if I highlight 5 months I'll have the comparison Jan'14/Feb '14/Mar '14/Apr '14/May '14 VS Dec '13/Jan'14/Feb '14/Mar '14/Apr '14 and so on...it is possible (and if yes, how) to do it through set analysis or I need to write a macro?
aha ...
Simple example for you.
I hope, that it halps.
regards
Darek
Thank you Dariusz Mielczarek...it's half way of what I need though, and I have actually already found something like that in the community...I was hoping for the complete solution. But thanks anyway for answering me!
What do you need more?
I need the comparison with the same number of months that I select -1.
So I select Jan2014-Feb2014-March 2014 I would like to see at the same time Dec2013-Jan2014-Feb2014 and so on...if I select 6 months Jan'14/Feb '14/Mar '14/Apr '14/May '14/Jun '14 I want to see also Dec '13/Jan'14/Feb '14/Mar '14/Apr '14/May '14....
Maybe you simple dont need DIM_MONTH in your chart dimension?
It will then present result for all months:
for example if you select:
Jan2014-Feb2014-March 2014
then you will have sum of sales for those 3 months as CURR
And sum of sales for Dec2013-Jan2014-Feb2014 as PREV
next examle
if it is not you need, please do xls showing chart you like to have
regards
Darek
I don't think...I need that variable! I want to see each month in both periods. at the moment the best thing I could find in the community is this:
but the comparison it's between the same months from different years...
In my first example you have dimension: DIM_MONTH
But for each month you have 2 values:
- this month value
- prev month value
So, for 1-2014 under CURR you have sale (1-2014) but under PREV you have sale (12-2013), etc
Please select come customer, and then look on values in straight table ....