Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
just use SUM()
=Sum(total) // by each dimension
or Sum(TOTAL total) // OVERALL totals
or Sum(TOTAL <CurrentDay> total) // Totals by CurrentDay
just use SUM()
=Sum(total) // by each dimension
or Sum(TOTAL total) // OVERALL totals
or Sum(TOTAL <CurrentDay> total) // Totals by CurrentDay
Thank you for helping, Vineeth !😁