Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
With the help of forums,
I Create a Pivot Table with Item and MonthYear as Dimension and Sum(Quantity) as expression And this is the result:
item | Monthyear | ene 2015 | feb 2015 | mar 2015 | abr 2015 | may 2015 | Total |
88126 | 1 | 30 | 87 | 0 | 0 | 130 | |
91152 | 143 | 97 | 136 | 206 | 82 | 976 | |
91156 | 162 | 66 | 154 | 129 | 120 | 1006 | |
91158 | 13 | 22 | 19 | 25 | 25 | 175 | |
91159 | 19 | 42 | 77 | 34 | 54 | 256 | |
91230 | 8 | 33 | 46 | 48 | 52 | 267 | |
91232 | 0 | 0 | 0 | 0 | 0 | 1 |
Now, I already have as well as the months I mean, how do I add January and February, February and March, March and April and so on. I need to add two and two and leave the results in a column. Because then I get the standard deviation of the months grouped in pairs.
I need this?
item | Monthyear | ene 2015 | feb 2015 | mar 2015 | abr 2015 | may 2015 | jan+feb | feb+mar | mar+apr | Standard deviation |
88126 | 1 | 30 | 87 | 0 | 0 | 31 | 117 | 87 | 44 | |
91152 | 143 | 97 | 136 | 206 | 82 | 240 | 233 | 342 | 61 | |
91156 | 162 | 66 | 154 | 129 | 120 | 228 | 220 | 283 | 34 | |
91158 | 13 | 22 | 19 | 25 | 25 | 35 | 41 | 44 | 5 | |
91159 | 19 | 42 | 77 | 34 | 54 | 61 | 119 | 111 | 31 | |
91230 | 8 | 33 | 46 | 48 | 52 | 41 | 79 | 94 | 27 | |
91232 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Please help me as I do this?
Hi Rodrigo,
As Digvijay pointed out that's the way to do it. Although, I am confused when you say "disaggregate for months".
Hi Sinan,
Thank you very much for your help, this is the original file, you can see the file information in the months this in a single column, I need to pass rows to columns (to what I mean when disaggregating)
use the function in the expression as Digvijay Singh he tells me not work for me, not that I'm doing wrong.
Best regards,
Rodrigo
Ok. I see.
I did the same way as Digvijay pointed out:
use set analysis, filter is the monthyear as shown in the above depiction. Then label it as the monthyear name that is used in the set analysis
I am also attaching qvw for your reference.
Thanks
Hi Sinan Ozdemir and Digvijay Singh,
Thank you very much for your help was invaluable
You can mark this 'answered' if it met your requirement to close the thread. Mark Sinan' one as right answer as I just followed his instructions. I am a learner.