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.
//Martin
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])
END
WHEN FALSE THEN sum([NetTurnoverActual])
END
But when I ad a dimension to the color shelf the line is broken up by the meassures which I don't want.