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|
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|
Please help me as I do this?
One way to do is to use Column() function:
So for jan+feb - Column(1) + Column(2)
for feb+mar - Column(2) + Column(3)
for mar+apr - Column(3) + Column(4)
Mind you that I am assuming that ene 2015 is an expression and it is the first expression in your pivot table.
Hope this helps.
Thank you very much for your help, I appreciate very much your comments,
I have Pivot Table with Item (codigo) and MonthYear as Dimension and Sum(Quantity) as expression And this is the result (dimensions):
After leading the column function, I have this:
Please help me again, as I do to disaggregate for months as you shown in the picture
Either remove that dimension or hide it by using "Enable Conditional":
0 will hide this dimension and 1 will un-hide it.
Hope this helps.
Hi Sinan Ozdemir,
To remove the dimension column I lose months
How else I can take months in columns without him as dimension, that I have because every month are in one column and the column I need is a month.
Thanks, I appreciate your help, you know a lot and I'm just learning