How to show the values corresponding to the maximum period of a group

[vishus913]

Hi All,

I have a table in my data model which is as below:

Worker     Period                 Plan

A                 nov 2018           10

A                oct 2018             15

B                nov 2018           11

C                 Aug 2018           12

C                Sept 2018             15

Now I want to show my output as

A                     Nov 2018              10

B                   nov 2018                 11

C                 Sept 2018                15

I want to this at UI only using set analysis or some other logic.

Kindly help to how to do so

Regards,

Vikas

[pathiqvd]

Hi ,

    Try This,

Sum({<Period={"=aggr(max(Period),Worker)"}>}Plan)

Regards,

[vishus913]

Hi,

It didn't work

[vishus913]

@Sunny talwar,

Any help over this please?

[sunny_talwar]

May be using FirstSortedValue() function

FirstSortedValue(Plan, -Period)