Show Max Date Row in Front End table

[pratham39]

Hi Everyone,

I have below table on frontend 

I want below in output - 

where only those ID will be shown where Date is maximum (Department wise Max Date)

Please help me to write Set analysis

Thanks

[MayilVahanan · Accepted solution]

Hi

Try like below

Dim: ID, Dept

Exp: If(Date = max(Total<Dept> Date), Date)

[pratham39]

Hi sir,

First of all thanks for reply

I tried this way below output i m getting where null values are also there 

I dont want null values in table 

[MayilVahanan · Accepted solution]

You can remove null values from Add-ons tab.

[pratham39]

Yes It worked .... i m accepting it as a solution... but will you please look that without using Addons can we do this?

Thanks

[MayilVahanan · Accepted solution]

You can try with Dimension instead of measures

=Aggr(If(Date = max(Total<Dept> Date), Date), Dept, ID)

and uncheck include null value checkbox

[pratham39]

Hi thanks sir 

this expression as dimension also worked

Thanks lot