Column % to Total calculation in pivot table

[CB308]

I have a calculated column (which is the total of column(1)+column(3)+column(5)+column(7)  labeled "4MthPlan"

In a pivot table, I would like to show the % to total of this column "4MthPlan" to the total of "4MthPlan".  See example below of expected data.

I have tried the following and none work.

sum("4MthPlan") / sum (Total ("4MthPlan"))

sum(column(8) / sum (Total (column(8))

Any suggestions?

product	4MthPlan	LastYear	Plan% Ttl	Plan%LY
Totals	1415	435	100%	225.3%
Travel	500	200	35.3%	150%
Soft	850	225	60.1%	277.8%
Access	65	10	4.6%	550%

[dwh1104 · Accepted solution]

I think one way you can accomplish what you are trying to do is by using variables.  See the attached QVW.

[CB308]

THANK YOU!!  Worked perfectly