Say I have 2 cells in a pivot table:

A1: with value of 1 A2: with value of 2

Now I want to calculate the percent difference between them simultaneously.

I know I can do it one-at-a-time by creating a new value field, then going to Value Field Settings, Show Value As, and choose "% Difference From". However, this will calculate the value of A2, as compared to A1 (or vice versa).

I want a way to calculate BOTH at the same time, showing the % difference of A2 vs. A1 and A1 vs. A2.

Is there a way to do this with pivot tables, or do I have to resort to doing things manually using formulas?

I'm using the latest version of Excel.