1 Reply Latest reply on Dec 6, 2018 12:29 PM by Joe Oppelt

    actions - Determine is a Filter has a selection?

    Victoria Leon

      Is there a way to detect, in the target sheet or in a calculated field, if the action filter has been selected?

       

      I would like to display a data is the action filter has been selected and another if the action is "ALL" or without filtering.

       

      I tried a calculated field with true or false, but all the time is true. (It represented a SET)

       

      Regards,

        • 1. Re: actions - Determine is a Filter has a selection?
          Joe Oppelt

          Create two calcs:

           

          Data in Data Source:    { FIXED : COUNTD([whatever dimension you are analyzing]) }

           

          Data on sheet:  { EXCLUDE [Dimension 1 on sheet] (, [Dim 2 on sheet], [dim 3], ... [last dim on sheet]) : COUNTD([Whatever dimension you are analyzing]) }

           

          The second calc needs to exclude every dimension on the sheet.  Then do a countD of the dimension.

           

          If these two calc values match, the ALL is selected.  If not, then some filtering has occurred.