vishus913
Partner - Creator
2018-11-23
02:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to show the values corresponding to the maximum period of a group
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
996 Views
4 Replies
pathiqvd
Creator III
2018-11-23
05:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
Try This,
Sum({<Period={"=aggr(max(Period),Worker)"}>}Plan)
Regards,
970 Views
vishus913
Partner - Creator
2019-09-20
07:33 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
It didn't work
913 Views
vishus913
Partner - Creator
2019-09-20
07:35 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Sunny talwar,
Any help over this please?
910 Views
sunny_talwar
MVP
2019-09-20
07:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be using FirstSortedValue() function
FirstSortedValue(Plan, -Period)
903 Views