Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a situation like this:
DATE | Code | N. Piece | Amount |
---|---|---|---|
201705 | A | 5 | 50 |
201705 | B | 8 | 100 |
201705 | C | 6 | 75 |
201706 | A | 12 | 80 |
201706 | B | 15 | 122 |
201706 | C | 10 | 90 |
201707 | A | 19 | 101 |
201707 | B | 22 | 134 |
201707 | C | 21 | 98 |
The Date format is 'YYYYMM' .
Every month has about 130.000 rows and the Measures are cumulative from the previous month. What I need is calculate the Delta between months and I cannot use function like "Before" or "Above".
So I thought to use Set Analysis but when I use Date-Function for filter by the previous month the sistem returns me 0 or in others cases the identical value of the month instead of the previous.
I hope to be exhaustive.
Can someone help me please?
Thank you All.
May be implement The As-Of Table
May be implement The As-Of Table
or share a sample to show your issue? I wonder why you can't use Above or Below?
Hi Chiara,
if the measure is cumulative like you said, then I think the discrepancy between months is just the delta, isn't it?
Thanks
Aiolos
It works!
I cannot use "Above" or "Below" because they don't work with the selection on a single month.
Thank you very much for you help!
Bye
Hi Chiara,
this is an implementation with the AsOfTable. I hope this can help you.
BR,
Sandro
There are ways to make Above/Below work with selection of Month also...
Above(Sum({<Month>}Sales)) * Avg(1)
Here Sum(Sales) will ignore selection in Month field to pull the value of previous dimension to this dimension and Avg(1) will make sure that only current dimension is shown as Avg(1) = 1 for current selections and 0 for out of selections
Hi Sunny,
at the moment I have a new issue.
I need to create the same process but for successive months.
In january 2017 I have to use the value of february 2017 and in other case march 2017.
Is it possible?
Thank you!
Should be possible... can you elaborate a little more and may be share a sample?
Here is an example.
I have to reproduce the same behavior of the "RESULT A" and "RESULT B".
I could sum the mesures using "MonthDiff" but how can I get the numerator?