Calculating Yearwise Sales

[#1]

Dear Folks,

              I have attached the excel sheet what i want to calculate in pivot table. can u please suggest me the expression ASAP.

[sujeetsingh]

Unable to see the doc data .

Can you post a sample to me or explain in details

[MayilVahanan]

Hi

For that, you want to create separate expression.

Like

2010 =Sum({<Year = {2010}>}Sales)

2011 =Sum({<Year = {2011}>}Sales)

2011-2010 =Column(2) - Column(1)

[#4]

Dear Folks,

This is the data i need

Year		2,010	2011	Diff(2011-2010)	2012	Diff(2012-2011)	2013	Diff(2013-2012)
Item
AAA		664	210	-454	275	65	99	-176
BBB		0	90	90	1,252	1,162	607	-645
CCC		-6	1	7	678	677	3	-675
DDD		9,210	30	-9,180	14,852	14,822	-35	-14,887

[Anonymous · Accepted solution]

Hi,

Please find the attached which I using Before() function to calculate different of the year.

[#6]

Dear Jerry

           Thank u very much. thats what i want..

Regards

Sakthi.S