How to create a column in a pivot to calculate the percentage evolution between the 2 others columns

[#1]

Hello

I have a pivot table with the simple expression sum(k_usd)

and it shows for each year the sum of the spend amount.

I would like to add a column to make the percentage evolution between 2011 and 2010.

Does someone could help ?

thanks in advance

[clisboa_noesis]

Hi,

If the value for 2011 and 2010 are already calculated in specific columns it's as easy as using column function, as stated in help:

Column(ColumnNo)

Returns the value found in the column ColumnNo in a straight table or a pivot table.

Example:

column(1)/column(2) returns the quotient.

Only count the expressions ones - the dimensions don't count for this.

[#3]

Hello,

Try the column() function. If you have the values for 2011 as expression 1, and the values for 2010 as expression 2, you simply add a third expression looking something like this:

((column(1)/column(2)) -1

Regards