Pivot Table - column showing %

[knobi]

Good morning !

I'm trying to add % column to the pivot table below :

City	Fruit	Total	Trash	% Trash
city_name1	apple	100	3	3%
city_name2	pineapple	50	10	20%

In this case, I dynamically built everything except the last column (not present in the data today) using a pivot table.
I would like to know if it would be possible to add only inn the pivot table, the last column showing the %, based on the numbers from the same line (total and trash).

Any help is welcome ! thanks !!

 

[knobi]

anyone, pls ?

 

[SpillerBD]

Have tried building a calculated field?

 

[knobi]

yes... but i would like to know if it's possible to do it thru the pivot table. The example above is a small portion about what needs to be done.
Thanks !

 

[Alex Blakenburg]

yes... but i would like to know if it's possible to do it thru the p@spivot table. The example above is a small portion about what needs to be done.

I am pretty sure you have misunderstood @SpillerBD's suggestion of a calculated field.
The calculated field is a Pivot Table calculated field PivotTable Analyze > Fields, Items & Sets > Calculated Field ..., see image below.

Result after applying a number format and changing the heading:

 

[knobi]

That was exactly what I was looking for ! thank you very much Alex Blakenburg by showing the steps !!!

 

[Alex Blakenburg]

No problem. Glad we could help.