Calculated Field in pivot table difficulty

[bluefish44]

Hi All - If I have two fields of data. One being Year and the Second being a number of Leads, Can I create a pivot table calculated field to show the Year over Year %?

So for example if data looked like this:

2023 10
2024 20
2023 20
2024 40

I'd then want to pivot the data and create a calculated field that says year over year in 200% (sum all 2024 / sum all 2023) ...is this possible?

 

[GraH]

It's a setting in the pivot. Slide the value in the Values sections. Right click and from the context menu select one of the options shown below: % of or % Difference From.

 

[bluefish44]

this seems to be a valid workaround - thank you