Problem with Max[,rank]

[Anonymous]

Hi,

in this thread i asked Expression - Filter for dimension

if i use a dimension in a chart and want to filter the values of the dimension, how can i do it?

The answer was for example

=if(Name='*Samsung*',Name,Null())

Now i want to use Max() in an expression like this:

=if(date = Max(Total date,2),Sales,Null())

The editor shows "ok", but the chart table shows only grey fields.

I test this expression

Max(total date,2)

and this one

=if(date = Max(Total date),Sales,Null())

Both shows the correct data.

What´s wrong in this expression?

=if(date = Max(Total date,2),Sales,Null())

regards,

sam

[sunny_talwar]

May be you need this?

=if(sDate >= Max(Total sDate, 2), Number, Null())

[Anonymous]

Mhh, no this is not what i mean.

In column 3, i want to show the difference from numbers of the latest date - number of the previous month. The correct result would be 10 in this case.

[sunny_talwar · Accepted solution]

Try this

=Aggr(FirstSortedValue(Number, -sDate) - FirstSortedValue(Number, -sDate, 2), Product)

[Anonymous]

Thank´s it works.

Why is there an empty row? Can i remove this row?

[sunny_talwar]

Uncheck 'Include Null values' under the data tab for your dimension