display/calculate weeks over years without actual date

[#1]

Hello community,

I have week, month and year as fields (no actual dates). Week and month are not related (two different reports) thus exclude each other.

How can I show the last 12 weeks (starting with the selected week) in a pivot and also considering the weeks of 2013?

I tried concatenating Year & Week but it didn't work.

Do I have to create a master calendar or is there some "easier" way?

If master calendar is the only way how should I go about it?

Week/Month data: [1,2,...,10,11,...]

Thank you,

Thorsten

[jagan]

Hi,

Can you attach the sample file and come up with an example what you need exactly.

Regards,

Jagan.

[#3 · Accepted solution]

I was able to get what I want after creating a calendar and linking that month with my month field.

Then in the expression I wrote:

sum({<Year=, CalendarMonth=, Date={'>=$(=addmonths(max(Date), - ($(vSetCalendarRange)-1)))<=$(=addmonths(max(Date),0))'}>} (Amount))

which gives me the right range based on the month selection.

Thank you all for the details.