Paper totals 24 kg and Metal totals 16 kg. To see their shares of all included material, divide by the grand total of 40 kg.

Choose % of Grand Total on the summed value field

In Ulet’s PivotTable dialog, keep Sum as the weight aggregation. Set Show values as to % of Grand Total and apply it. Paper should show 60% and Metal 40%.

The Paper and Metal totals make the grand total of 40 kg.

Illustrated denominator. Keep Sum as the aggregation.

Check the total again when filters change

Verify 24 ÷ 40 by hand and compare the two shares. If both say 100%, check that the denominator is the whole pivot rather than each row’s own total. Review which records contribute after applying a filter, and keep the weights available for comparison.

The 24 kg Paper total divided by 40 kg is 60 percent.

Illustrated share check. Verify what contributes after filtering.

Microsoft’s PivotTable value calculation reference