Set Analysis Syntax

[ziadm]

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

[sunny_talwar]

Try this approach instead:

The As-Of Table

[swuehl]

I think you should apply something like an AsOf table

The As-Of Table

or a canonical date

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).