Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. Here is my problem.
If the total number of records is greater than 12, display only the last 12
and
If the total number of records is less or equal 12, exclude the 2 first
Records >12
Records <=12
Thank You!
replace with
=date(
if(count(TOTAL d)>12,
if(aggr(rank(d),d)<=12, d, null()),
if(aggr(rank(-d),d)<=2, null(), d)
)
)
see attachment
He,y thanks.
It works only when records are <=12.
When greater than 12, not.
The result should be like this:
Thanks again.
replace with
=date(
if(count(TOTAL d)>12,
if(aggr(rank(d),d)<=12, d, null()),
if(aggr(rank(-d),d)<=2, null(), d)
)
)
Wow! Perfect!
Thank You so much.