Pivot Table formula when items are in same column

[jenjen115]

Hello
I have two columns: One has a drop down to select two items, the other has the value. I want to create a percent between the two in a pivot table.

I want to create pivot that divides Amount review by Spend. I don't want to write a formula in my source data because I will add rows and delete rows

How do I write a formula in a pivot table to get the results in columns P-V

table for the

 

[GlennUK]

Your data layout is not what I would consider logical. If you rearrange, as below, your PivotTable can be generated with an additional calculated field:

 

[jenjen115]

Thank you- I realize the set up is not ideal- it is part of a larger file- However, I was able to do this, with something called "Calculated Item". From "Fields, Items, & Sets". I have the solution, thank you.

 

[GlennUK]

Glad you found a solution.