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%.

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.

Illustrated share check. Verify what contributes after filtering.



