how to do sum for the rows in pivot table

[#1]

i should make sum for the rows in Pivot table

[#2]

if I need to show it in % persentage what can i do

[Gysbert_Wassenaar · Accepted solution]

On the Number tab format as a percentage by checking the Number or Fixed to option and check the Show in Percent (%) option. If you want the rows shown as a percentage of the total you need an expression like: sum(Value) / sum(total Value). Replace Value with whatever field or expression you want to sum.