Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Need the max record, depending on the max date. See below.
Can not use something like that, because there is nothing to aggregate (for instance in Column "Sync_Key"):
Sum({$<%Date = {"$(=Max(%Date))"}>} Sync_Key)
Thanks.
%Date | User | Sync_Key |
01.01.2020 | Albert | Albert | 01.01.2020 |
02.01.2020 | Albert | Albert | 02.01.2020 |
03.01.2020 | Albert | Albert | 03.01.2020 |
01.01.2020 | Stefan | Stefan | 01.01.2020 |
02.01.2020 | Stefan | Stefan | 02.01.2020 |
Result: | ||
%Date | User | Sync_Key |
03.01.2020 | Albert | Albert | 03.01.2020 |
02.01.2020 | Stefan | Stefan | 02.01.2020 |
Don't understand. These are to functions; where to put it? If I put only FirstSortedValue(Sync_Key, -%Date) in a separate Dimension, does not work
@george55 You need it as a dimension? Try this
User
Aggr(FirstSortedValue(Sync_Key, -%Date), User)
Aggr(Max(%Date), User)
can you try this?
=sum({<%Date={"$(=Date(Max(%Date),'DD.MM.YYYY'))"}>} sync_key)
Best
Chanty
Hi and thanks all of you, but none of these formula worked:
User Aggr(FirstSortedValue(Sync_Key, -%Date), User) Aggr(Max(%Date), User) // Error: not valid Dimension
Sum({<%Date={"$(=Date(Max(%Date),'DD.MM.YYYY'))"}>} Sync_Key) // Error: not valid Dimension
User Aggr(FirstSortedValue(Sync_Key, -%Date), User) Aggr(Max(%Date), User) // Syntax Error
FirstSortedValue(Sync_Key, -%Date) Date(Max(%Date)) // Syntax Error
Have only these 4 Dimensions in the Outputtable, no measures: