I am using 10.0 so I am unable to open your twbx. But I really appreciate a quick response.
I request a favour. Can you please share the screenshot of the final outcome if possible and some insights into calcs :-)
Well thanks Chris. You Nailed it. Brilliant.
That's strange, I'm using v.10.0.2 and it works perfectly, but anyway ...
Act/Fcst = If [Metric] <> 'Budget' then [Value] END
Budget = If [Metric] = 'Budget' then [Value] END
When I pivotted the data I called the columns "Metric" and "Value" (without the quotes)
I think that's all you need
Thanks for quickly reply~