Hi
I'm wanting to know how show percentage as a value in a pivot table. I want to know how to remove calculation. I tried using the value field setting and choose no calculation but it's still showing the percentage as a calculation not value. Also in the subtotal column, i don't want to show the percentage as a total but as a value.
Thanks
I'm wanting to know how show percentage as a value in a pivot table. I want to know how to remove calculation. I tried using the value field setting and choose no calculation but it's still showing the percentage as a calculation not value. Also in the subtotal column, i don't want to show the percentage as a total but as a value.
Thanks