Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Ernesto_Granadillo
Contributor
Contributor

Capture the last loaded value

Hi,

It is necessary to capture the last loaded value (objective) for a specific dimension and add those values ​​to have a total of the loaded values ​​(total objective).

The following statement is being used, but it is not taking the last loaded value:

• Sum (Aggr (Max ({1} [58]), PUBLIC_ID)).

Labels (1)
2 Replies
Anil_Babu_Samineni

May be

FirstSortedValue(PUBLIC_ID, Aggr(Max({1} [58]), PUBLIC_ID))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Ernesto_Granadillo
Contributor
Contributor
Author

It worked to place the value of each sales manager, but it does not seem to me for the total of the values ​​that are displayed.

Display attached image.