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

    Column Selector with Global Filter




      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?