Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In one of my pivot tables I get the grand totals for each column (formula) showing. I want to convert that total into a variable so that I can calculate the percentage of each row as a percent of the total for each column. How can I declare the column total as variable. Please helpl
Hi,
Create a variable and give the expression you used in the Pivot table.
Now use this variable in your expression
=Sum(Revenue)/$(vTotal)
or you can use directly without creating any variable
=Sum(Revenue)/Sum(TOTAL Revenue)
TOTAL doesn't consider the dimension, so you will get the Column total when you use TOTAL in expression.
Regards,
Jagan.
Is it possible to attached the file you are currently working on?
Hi,
Create a variable and give the expression you used in the Pivot table.
Now use this variable in your expression
=Sum(Revenue)/$(vTotal)
or you can use directly without creating any variable
=Sum(Revenue)/Sum(TOTAL Revenue)
TOTAL doesn't consider the dimension, so you will get the Column total when you use TOTAL in expression.
Regards,
Jagan.