group data and calculations of a pivot table

[#1]

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?

[sinanozdemir]

Hi Rodrigo,

As Digvijay pointed out that's the way to do it. Although, I am confused when you say "disaggregate for months".

[#3]

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

[sinanozdemir]

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

[#5]

Hi Sinan Ozdemir and Digvijay Singh,

Thank you very much for your help was invaluable

[Digvijay_Singh]

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.