Filter for date

[Anonymous]

Hi all,

I have an ordered date which I wish to create a filter on.

The filter should be as follows:

• This week
• Last week
• This Month
• Last Month
• Last 3 months
• Last 6 months
• This year.

I cannot create a single dimension field for all this, the reason being it won't select all I need.

For ex: If I select this month, then it should select the components of "This Week" as well.

Could someone please give me a direction as to how I should go about this?

[Anonymous]

Thanks for the ideas Jose. I was able to achieve it with the above method.

A bit of a workaround but still good enough.

Thanks.