Query regarding add field(percentage) from Value in Pivot table


I want to add new calculated or other field in Pivot field on the basis of Values.

I’ve below 2 values and from that I need to calculate % for next new column which I require.
Value Column 1 → $24,406.58
Value Column 2 → $53,268.69

It’ll calculate percentage 118.26% for the next column in Pivot table.


Thanks for reaching out. You can do this by adding the value twice and on the second instance use a table calculation directly from the pivotTable field well menu. No need to write the calculation. Here is what I have.