Ok here goes:
I'm showing a line of quantity over time (month) for a year. I'm trying to construct a calculation that will enable me to show order quantity when the maximum date of my data set is passed. In other words when there's no more actual data show order data from that date.
Any help is much appriciated.
This is what I have now:
CASE sum([NetTurnoverActual]) = 0
WHEN TRUE THEN
CASE [Choose Turnover]
When 1 THEN sum([NetTurnoverActual]) + sum([NetTurnoverOrder])
When 2 THEN sum([NetTurnoverActual]) + sum([NetTurnoverBudget])
WHEN FALSE THEN sum([NetTurnoverActual])
But when I ad a dimension to the color shelf the line is broken up by the meassures which I don't want.