Hi all,
I'm building a report on top of our weekly sales data warehouse. In this datawarehouse we also have monthly forecast data, which is loaded to the 1st day of the month. So when I run my report, the amount of the forecast is displayed in the 1st week, rather than just as the month total. Also, see the green bar in the attachment (fake data).
How can I fix this? Is there a way to set a "filter" so that the Forecast measure is only shown for the total month?
Thanks
Sander