Hardcoded pivot table into a dynamic pivot table

[#1]

Chaps, I had a pivot table where all the expressions were hardcoded, which means after every load we had to adjust the expressions. I am in the process of making that a dynamic pivot table. I have achieved 50%. I have got the basic expression right, but now I want to arrive at the change and the change % dynamically. I think I should use Column(2)-Column(1) in a dynamic fashion. Is there a method to get the current column position in terms of the expression. Something like Column(currentcolumn) - Column(currentcolumn-1), which will be helpful to me.

Also in this case there is just one expression. So I don't think Column() function will work.

Please find attached the screenshots, that should give you an idea of what I actually want to achieve.

Thanks,

Ram

[MK_QSL]

Hi, Can you please provide sample data?

[nizamsha]

if ur expression is right in both the column mean u can do that column(2)- column(1)

or u can give the label name- label name

[#4]

no Nizam, there is just one expression. So cannot use column() function.

[#5]

actually I thought above(sum(<expr>),'Period',-1) would have been more appropriate, but that didn't work.

[#6]

can be something like this

PeriodCode Count

Feb2014    1000

Sep2013    2000

Jun2013     1500

Mar2013     600

[#7]

if my actual expression is

sum([Employee Count])

can't I say

sum([Employee Count)

-

above(sum([Employee Count],'Period',-1))

won't that work?