Excluding Filters in the expressions

[ishanbansal1204]

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.

[shraddha_g · Accepted solution]

Try,

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

[ishanbansal1204]

Thank you Shraddha.