set analysis formula

[#1]

can you use set analysis to look at only certain parts of a field?

For example, I have the calendar dates as 201438, 201439, etc... for forecasts but I also want to show sales.

what expression can I use to say only look at the sales for week 38 from year 2013...

[lucianosv]

Has your week field tis format 201438?

If yes, 201438 - 100 = 201338 and 2014 - 200 = 201238.

There is something wrong in your script.

[#3]

Hi

Please find attached file for your expected answer.

Hope this will help.