Aggr with Max

[lucasx15]

Hi all,

Kindly help me out in the below scenario,

I have a column in which I have the Section(the section numbers are just identifiers), CURRENT DAY AND THE TOTAL OF OCCUPIED BANKS IN EACH SECTION. I need to make the sum of these totals in an object, the total sum needs to be 314.

However, I thought about aggregating the total by section and current day. So I can keep up with each day. I made the following expression, however, it does not return the total value.

FirstSortedValue(TOTAL, Aggr(SUM(TOTAL),CD_SECTION,DT_CURENTDAY))

[vinieme12 · Accepted solution]

just use SUM() 

=Sum(total)   //      by each dimension

or Sum(TOTAL total)  // OVERALL totals

or Sum(TOTAL  <CurrentDay> total)  // Totals by CurrentDay

[lucasx15]

Thank you for helping, Vineeth !😁