Pivot table %

[#1]

Hi all,

I got a pivot table containing the following information:

Divsion Name     weeks:     Revenue 2014     Planned 2014    Revenue Cumulative 14     Planned Cum 14

-                         1

                          2

                          .....

                         53

Now i want to divide the Revenue cum 2014 / Budget cumulative to get a % that shows me how much of the planned Revenue has been achieved. However i can't seem to get the right expression(definition) that will show me this %.

Any got a clue what I am doing wrong?

[Gysbert_Wassenaar · Accepted solution]

Try use column references. Either use the labels [Revenue Cumulative 14]/[Planned Cum 14] or column numbers column(3)/column(4)

[#3]

Thanks for the quick response Gysbert.

Using the column function gives me the right results however if I would add another column inbetween the 3d and 4d column I need to change the columns to 4 and 5 and 5.

[Gysbert_Wassenaar]

That's why it's also possible to use expression labels.

[#5]

Yes, using those is the best option. Thank you very much!