set analysis variable Year Week

Tue, 04 Aug 2015 06:21:07 GMT

hi i would like to perform a point in time report.

i am currently trying to point back to the previous year and week based upon my selection.

my selection in this case is 201531 so i would like to return the values for 201431.

please see my attempt below

sum(<{[Year Week] = {$(=(Only(Year)-1)) & $(=Only(Week))}>}

Sales)

Re: set analysis variable Year Week

Gysbert_Wassenaar — Tue, 04 Aug 2015 08:35:20 GMT

Try sum(<{[Year Week] = {$(=(Only(Year)-1)),$(=Only(Week))}>} Sales)