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

Question & Answer
1

Hello,

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.

2

Hi,

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.

image
image1670×1498 117 KB

Best,
Sean