Pivot - adding a calculated field

[Ballet4ever]

Hello,
Is there a way to add a calculated field that divides data by a variable? The attached sample file contains a Pivot table summarizing sales and cost data (Sales Volume, Fixed Costs, Revenue, Selling expenses, Variable costs) for multiple years and multiple companies (A & B). The Pivot has Company and Year Filed in Filters. I need to add a column to the Pivot which will calculate the sales and costs data (Parameters) per Sales Volume (one of the parameters), by dividing the parameters (fixed costs, Revenue, Selling Expenses) by the Sales Volume (Items Sold). The data Pivot should recalculate every time the new filter (company and year) is applied.
Thank you!

[romperstomper]

Add the value field again, right-click the new copy and choose Show Values As, % of... then choose Parameter as the base field, and 'Sales Volume, items sold' as the base item.

[Ballet4ever]

Great! Thank you!

[Ballet4ever]

It worked great in a simple example I provided. Now I have complicated things and added columns to the data. Now the pivot has multiple groupings, and the calculation is not working well. Can you tell me why I have N/A error in some rows?Example-Pivot per item sold_Rev 1.xlsxNA Error with Groupings.JPG

[romperstomper]

The 'Sales volume, items sold' field only has a value at Cost Center level for Sales, so you will get N/A at that level for both PPO and OpEx since there isn't a value to use as the base.

[romperstomper]

If you use the data model, you can do something like the attached, which I think is what you are after?

[Ballet4ever]

Awesome! When you wrote the DAX formula, did you type the "Sales Volume, items sold" in the filter or is there way to somehow look this value up/choose from a list the same way you can pick column headers?
SalesVol:=CALCULATE(SUM([Content.Value]),Query2[Content.Parameter]="Sales Volume, items sold",ALL(Query2[Content.Cost Center]))

[romperstomper]

I wrote it in myself, but you could have a table of the parameters.