1 of 1 people found this helpful
Just looking through some unanswered questions and came across this one.
So one way that might work is as follows....
I've set up a parameter to control the before and after date (just helped me test it!)
So in the Primary Data Source I set up this calculation...
[Sales Before Order Date]
IIF([Order Date]<[Get Data From Primary Before...],[Sales],0)
and then in the secondary this one..
[Discount After Order Date]
IIF([Order Date]>=[Get Data From Primary Before...],[Discount],0)
btw I've deliberately used discount so it's apparent when the data switches (being on such a different scale)
Then back in the primary I create this calculation, which basically add these two together
[Sales to Show (Discount After Date)]
zn(SUM([Sales Before Order Date]))
zn(SUM([CL Training Data Source].[Discount After Order Date]))
ensuring that the blend field of Order Date is checked.
Hope that makes sense, and does the trick, but let me know if not.
Genius - thank you so much. Never would have figured that one out but it worked like a charm!