percentage in pivot table

[venkat1]

Hi 

can you please tell me how to give the percentage in pivot table 

[sunny_talwar · Accepted solution]

You had an extra parenthesis in there... try this

Sum(sale)/Sum(TOTAL sale)*100

[Anonymous · Accepted solution]

you need an additional bracket in your Formula
"sum(sale)/sum(TOTAL(sale)*100) "

then define the number Format to percentage