Running Sum Aggregation

[GayatriPanigrahi]

Hi All,

I have a day-on-day data and which has grouped by "CC","BA","Account" to calculate running sum and below is the outcome of running sum.

But the expectation is, if i select 03-04-2017 cumulative amount should be available i.e. all the values of 01-04-2017 and 03-04-2017.

I have records more then 10L, which is the best way to achieve the required output.

Attaching the input and required data workflow.

[RolandSchubert]

Hi @GayatriPanigrahi ,

I think, you have to create a list of all possible combinations of Date, CC, BA and Account (list of dates and list of combinations BA, CC, Account). You have to join the existing records to this list, including "unmatched" (i.e. date, that do not exist for a specific combination).

I've modified your workflow a bit. Let me know if it works for you.

Best,

Roland

[GayatriPanigrahi]

Hi @RolandSchubert 

Thank you for the quick response.

The permutation and combination of data is huge and in given solution append filed has limitation to create combination upto 16 records only.

[RolandSchubert · Accepted solution]

Hi @GayatriPanigrahi ,

you can remove this limitation by changing an option within the AppendFields tool:

Select "Allow all Appends" and it should work.