Column Selector with Global Filter

Question

Hi,

I have column selector with: Week, Month and Quarter. I used them in Pivot Table.

I want to interact this column selector with global filter.

For example:

When I choose "Time"."Week" I want to set global filter: DAY_NUM_OF_WEEK = 7

choose "Time"."Month" - > DAY_NUM_OF_MONTH = 31

choose "Time"."Quarter" - > DAY_NUM_OF_QUARTER = 90

How can I do this?

Maybe I can create formule (maybe with CASE WHEN) in global filters, but how can I refer to the selection column week/month/quarter?

choracy69 · Answer

Ok, it's working fine.

Thanks Gianni for help.

choracy69 · Answer

Thanks, I will try this condition.

Yes, I use this filter in Criteria.

Gianni Ceresa · Answer

You will need something a bit more complex for the filter as it must still be a SQL-like condition ....

So you can try a filter like :

( '@{Dim}{xxx}' = 'Month'

AND

DAY_NUM_OF_MONTH = 30 )

OR

( '@{Dim}{xxx}' = 'Quarter'

AND

DAY_NUM_OF_QUARTER = 90 )

(Just to be sure: this is a filter you want to use in your Criteria tab in the filter area, right? )