Hello community,
I have a table with data from various download dates since I need to show the development during the month. This is working fine.
I need an addiditonal table visual now, based on the same data, where only the most recent records is shown.
Here an example:
Extract from data in table WIP:
| Download Date | Reporting Period | OrderType | Product | Company | SystemStatus | Object | OrderText | Installation | Last cost aging | PCA_WIP | CustomerName | OrderStatus | Coordinator |
| 31 Dec 2021 | 31 Dec 2021 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 1 | 11.589 | example Ltd | NoBill | Sam |
| 31 Jan 2022 | 31 Jan 2022 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 3 | 102.921 | example Ltd | NoBill | Sam |
| 28 Feb 2022 | 28 Feb 2022 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 12 | 147.044 | example Ltd | NoBill | Sam |
| 31 Jul 2022 | 31 Jul 2022 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 20 | 99.999 | example Ltd | NoBill | Sam |
| 31 Aug 2022 | 31 Aug 2022 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 13 | 101.120 | example Ltd | NoBill | Sam |
| 30 Sep 2022 | 30 Sep 2022 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 9 | 101.164 | example Ltd | NoBill | Sam |
| 09 Nov 2022 | 31 Oct 2022 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 40 | 103.923 | example Ltd | NoBill | Sam |
| 21 Nov 2022 | 30 Nov 2022 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 5 | 103.989 | example Ltd | NoBill | Sam |
| 09 Nov 2022 | 30 Nov 2022 | ZS03 | A | xy | Not TECO | 11149571 | abc | def | 48 | 103.923 | example Ltd | NoBill | Sam |
User uses slicer on "Reporting Period", e.g. Nov 2022 and the desired output should be as below. Meaning only Reporting Period Nov 2022 and the most recent Download Date.
| Download Date | Reporting Period | OrderType | Company | SystemStatus | Object | Installation | Last cost aging | PCA_WIP | CustomerName | Coordinator |
| 21 Nov 2022 | 30 Nov 2022 | ZS03 | xy | Not TECO | 11149571 | def | 5 | 103.989 | example Ltd | Sam |
Can somebody please help me how to get there? Thank you!
