Hi,
I have weeks from week 1 in 2017 until week 1 in 2018. I need to show sales and forecast on the same line in a table (please see sample data below). Any suggestions?
week 1 week 2 current week week 4 week 5...........................................week 52
sales 10 11 ........................................................
forecast ....................... .5 6 7
Instead of two lines I would like to see:
week1 week 2 current week week4 week5
sales / forecast 10 11 5 6 7
Thank you,
Mags
Hey Magdalena,
You could use the following calculation to display the Sales or Forecast value based on what week we are currently in:
IF DATETRUNC('week',[DateField]) <= DATETRUNC('week',TODAY())
THEN [Sales]
ELSE [Forecast]
END
This will be dynamic so will reference the Forecast value until we are in that specific week of the year.
Hope this helps!
