Showing last value of specific dimension

[okin_pfa]

Hi,

I'm having problem with showing data in pivot table.

You can see, some WorkOrder having two values in Shift, but I would like to ignore first value and show only last one. 

[Chanty4u]

Try this 

=aggr(only({<Shift = {"=RowNo() = Max(Total RowNo())"}>} Shift), WorkOrder)

[BrunPierre]

@okin_pfa here's one approach from the backend.

Data:
LOAD WopId,
WorkOrder,
Shift

FROM SourceTable;

Inner Join
LOAD WorkOrder,
Shift

Resident Data
Group By WorkOrder;

[okin_pfa]

No, it's not showing anything