Forum Discussion
Create filtered table based on max value
Hi,
you have to group by
Expand all rows
add 2 conditional columns
and finally filter all Yes
(you obtain the company in alphabetical order, if you want the first you have to add an index before)
You can take a look at the attached file
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Hi,
you have to group by
Expand all rows
add 2 conditional columns
and finally filter all Yes
(you obtain the company in alphabetical order, if you want the first you have to add an index before)
You can take a look at the attached file
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Its removing some of my dates, I need to keep all the dates but it seems when it encounters the same duration for the same date and with a different company it removes the date completely. Please Help. Wondering if this is related to not adding the index, could you explain that step by step, thanks in advance.
Current Status
| Employee Id | Company | Date | Duration |
| 123 | Chicken Company | 1/1/2023 | 4 |
| 123 | Box Company | 1/1/2023 | 4 |
| 321 | Box Company | 1/2/2023 | 8 |
Error out of query:
| Employee Id | Company | Date | Duration |
| 321 | Box Company | 1/2/2023 | 8 |