Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
This is my file.
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
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