The last status

[#1]

Hi there,

I have charged the following information.

WAREHOUSE	DATE	STATUS
A	01/01/2016	ON LINE
B	02/01/2016	ON LINE
B	01/01/2016	OFF LINE
C	02/01/2016	OFF LINE
D	03/01/2016	OFF LINE
D	02/01/2016	OFF LINE
D	01/01/2016	ON LINE
E	03/01/2016	ON LINE

As I can get a table where I said the last date for store their audit and status ..

[Clever_Anjos]

Store as Dimension and

MAX(DATE) and FirstSortedValue(STATUS,-DATE) as expressions

[sunny_talwar]

May be this:

Dimension: WAREHOUSE

Expressions:

1) Date(Max(DATE))

2) FirstSortedValue(STATUS, -DATE)