Create cumulative numbers in load script

[mikecherry]

Hi all,

I am trying to get cumulative numbers in the load script like I have calculated using rangesum in the table below.

You can find attached the app and the data.

[DesmoArka]

I use your script at all.

I thing you are wrong only graph and not script.

Create this pivot and check if it's ok:

You must have Bunit in Graph

[DesmoArka]

This is my file.

[DesmoArka · Accepted solution]

and remenber that you are summing a field with cumulated value, u can't use that to total calculation.

Add this to the script:

left Join
load max(TransValueDate) as TransValueDate,
BUnit,
TransCcy,
1 as max_data
Resident Transactions1
Group by BUnit,
TransCcy;

and use this measure in my pivot:

if (Dimensionality()<=1, sum(aggr(Sum({<max_data={1}>}Trans_CUM),BUnit,TransCcy)), Sum(Trans_CUM))

I attached all file

[mikecherry]

Thank you man ! In the end I had to do a group by before your script as I had multiple transactions at the same date but after that I have used your script and works great !

Ciao

Michele