4 Replies Latest reply: Aug 3, 2018 2:42 AM by Manikantan S RSS

    Exclude One Filter alone when displaying certain fields

    Manikantan S

      HI All,

       

      I have multiple filters in a sheet, using which i want to display various data. There is one field 'Application Count' which i don't want to change whenever 'Month of Closed date' filter changes, but can change if other filters change.

       

      If i use the expression - Count ({<Closeddate =>} [Application ID]), its not working, since i have created filter on Month of the closed date.

      If i use the expression - Count ({<Month(Closeddate) =>} [Application ID]), its showing an error.


      Any advise on how i go about this?


      Yours Truly,

      S.Manikantan