1 of 1 people found this helpful
Create a calculated field like;
SUM(IF [Data Item Name] = 'Maximum' then [Aggregate] end) - SUM(IF [Data Item Name] = 'Minimum' then [Aggregate] end)
Then remove the 'Data Item Name' dimension from the rows shelf and you have your difference.
Find my approach as reference below and stored in attached workbook version 9.3
Minimum: if [Data Item Name]="Minimum" then [Aggregate] END
Maximum: if [Data Item Name]="Maximum" then [Aggregate] END
"Take and etc": if CONTAINS([Data Item Name],"Take and weigh 3 core") then [Aggregate] END
Delta max-min.twbx 1.1 MB
Thanks for the quick responses! Both answers achieve exactly what I was hoping for. Thank you very much!