2 Replies Latest reply: Nov 30, 2017 1:33 AM by Ishan Bansal RSS

    Excluding Filters in the expressions

    Ishan Bansal

      Hi ,

       

      I have an expression to calculate last 12 months of information.

      count(DISTINCT{$<WEEK=,MON=,QUAR=,SUBMIT_DATE={">=$(=MonthStart(AddMonths(Max(SUBMIT_DATE),-12)))<$(=MonthEnd(Max(SUBMIT_DATE)))"}>} [ID])

       

      As I have 3 filters in sheet 1 that is Week , Mon,Quar , whenever i apply these filters the value in the sheet 2 changes. is there any way that i can exclude filters in the expressions. appreciate your help.

       

      Thank you.