Actual vs Budget vs PY in a Matrix with Scenarios in the Column

[pgeary]

Hello,

I am trying to create a measure that provides one scenario (actuals) vs. a second scenario (budget). I can make actual sales vs. budget sales and get a figure, but I want the formula to be generic enough to use with any of my line items and get an answer.

i.e. a 4th column in the screenshot below for each line item a difference will appear based on each scenario (actual - budget and actual - PY).

🙂 Thanks.