Pivot Table formula when items are in same column

jenjen115

New Member
Joined
Aug 15, 2018
Messages
7
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

Screenshot 2023-08-09 113047.png
table for the
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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:
 

Attachments

  • CapPTpcent.JPG
    CapPTpcent.JPG
    86 KB · Views: 69
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,187
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top