Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)).
May be
FirstSortedValue(PUBLIC_ID, Aggr(Max({1} [58]), PUBLIC_ID))
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.