I am trying to recreate a table like this in Pigment where the scenario would be Actuals and Var $ and Var % are calculated items and $ per head is ‘Total $’ in ‘Show Values as % of’ format. In Pigment, the red cells end up calculating as a % of as well instead of a variance. Does anyone know of a work around for this? If I make an independent $ per head metric the total $ per head line will be inaccurate. Thank you!
