Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try use column references. Either use the labels [Revenue Cumulative 14]/[Planned Cum 14] or column numbers column(3)/column(4)
Try use column references. Either use the labels [Revenue Cumulative 14]/[Planned Cum 14] or column numbers column(3)/column(4)
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.
That's why it's also possible to use expression labels.
Yes, using those is the best option. Thank you very much!