Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
I think one way you can accomplish what you are trying to do is by using variables. See the attached QVW.
I think one way you can accomplish what you are trying to do is by using variables. See the attached QVW.
THANK YOU!! Worked perfectly