Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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])
Thank you Shraddha.