5 Replies Latest reply on Feb 5, 2016 11:47 AM by choracy69

    Column Selector with Global Filter

    choracy69

      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?