Exclude two first values (or not) of a Dimension

[#1]

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!

[maxgro]

see attachment

[#3]

He,y thanks.

It works only when records are <=12.

When greater than 12, not.

The result should be like this:

Thanks again.

[maxgro · Accepted solution]

replace with

=date(

if(count(TOTAL d)>12,

if(aggr(rank(d),d)<=12, d, null()),

if(aggr(rank(-d),d)<=2, null(), d)

)

)

[#5]

Wow! Perfect!

Thank You so much.