Calculated Item - Solve Order Formula

Sundance_Kid

New Member
Joined
Sep 2, 2017
Messages
48
Office Version
  1. 365
Platform
  1. Windows
Hi Folks

I have a pivot table.

Column A - shows a list of 12 products
Column B = Revenue from each product
Column C = Profit from each product
Column D = a Calculated Item column dividing column C by column B to get a % margin.

Everything works fine except that for one of the products it does not have a % calculation in Column D for it. When I click on the cell there is no formula, even though the cells above & below have the calculated item formula.
I went to the Calculated Item Solve Order section and in the pop-up I can see the product in the list but there is no formula beside it.

Any idea how I can update it? In the pop up for Solve Order there is only an option to Move Up, Move Down, Delete or Close.

Thanks
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Sundance_Kid

New Member
Joined
Sep 2, 2017
Messages
48
Office Version
  1. 365
Platform
  1. Windows
There isn't a collapsed field by chance? Can you share a screenshot with dummy data if needed?
Hi, thanks for your reply.

No there was no collapsed field. I ended up deleting the Calculated Item and then adding back - now the cell has the formula in it. Not sure what the issue was.

Thank again
 

Watch MrExcel Video

Forum statistics

Threads
1,130,302
Messages
5,641,423
Members
417,209
Latest member
Agbarker

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
Top