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

[#2]

Do you have the same kind of date format tied to sales as well?

[#3]

Yes Suraj

[#4]

Can you try this and let me know if this doesn't works. Sum({$<Dates={'201338'}>}Sales)

Thank you

Suraj

[#5]

It does not work.

The problem is that the forecasts are future dates, so 201442, 201443, and so on...while Sales are in past dates so 201339, 201348..and so on.

I need forecast and sales side by side...

[#6]

I see what you are saying now. If you can upload a sample document I can do it for you.

Thanks

Suraj

[#7]

Here is an example document of a similar solution.

Thank you

Suraj

[#8]

here is an example, thanks for your help

[#9]

Check this and let me know if that is what you are looking for.

Thank you

Suraj

[#10]

This is not working right. I don't see any of my forecast dates (i.e 201431,201432)