Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Calendar that looks like this
CALENDAR_DATE | WEEK_NUMBER | PrYrWeek |
5/2/2016 | 201614 | 201514 |
5/3/2016 | 201614 | 201514 |
5/4/2016 | 201614 | 201514 |
5/5/2016 | 201614 | 201514 |
5/6/2016 | 201614 | 201514 |
5/7/2016 | 201614 | 201514 |
5/8/2016 | 201614 | 201514 |
WEEK_NUMBER is the Week the date and PrYrWeek is the week number aligned from the last Year,
I have a chart the Dimension by WEEK_NUMBER and Sum(Sales) strgiht forward (NP)
I need to add another expression to the chart to Sum(Sales of PrYrWeek)
like this
Sum({ $<WEEK_NUMBER = {"=$(" & PrYrWeek & ")" } >} Sales)) . This does not work .. Any idea
Try this approach instead:
I think you should apply something like an AsOf table
or a canonical date
You basically need to create a link table with a field you can use as dimension in your chart, where each field value links to a calendar date field value from current and previous year (multiple records per dimensional value).