Pivot calculated field vs Datamodel measure

Hi

I do have a pivot table where I want to calculate the scrap percentage for each row vs the total output. I thought by creating a calculated field I can achive my target but its not working.

Using a Powerpivot and create the measure is fine.

HTML Code: 

This gives me the total value of the selection for my output column. This can be used to calculate the percentage of each row.

Question is, how can I get the same result with a calculated field or other ways without using the datamodel?

Thanks

Hi,

Calculated Field formulas cannot refer to the Pivot Table totals or subtotals. So if you don't want to use the data model you'd have to add the required total to every row within the source data table, then reference that within the Pivot Table, using e.g. MAX as the aggregation to ensure it is repeated identically for each row within the Pivot Table.

Regards