Change Solve Order for Pivot Table Calculated Items
In addition to the items that in a pivot table's source data, you can create calculated items in a pivot table, by using formulas.
If you have two or more calculated items in a pivot table, there might be cells that are affected by multiple calculated items. This can cause problems, if the formulas are not solved in the order that you expected.
Watch this video to see how to create the calculated items, and change the solve order for them, so the results are what you expected.
Visit my Contextures site for the sample Excel file and written steps.
https://www.contextures.com/excelpivo...