Column % to Total calculation in pivot table

CB308 — Thu, 16 Jun 2011 12:34:36 GMT

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%

Re: Column % to Total calculation in pivot table

dwh1104 — Thu, 16 Jun 2011 16:05:01 GMT

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

CB308 — Fri, 17 Jun 2011 12:26:34 GMT

THANK YOU!! Worked perfectly