Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
very quick question. I would like to accumulate over inner dimension (Dim2). Without editing script.
Current:
Desired:
accumulated sum(Exp) in Pivot table
24.1.2018 P0 23.25
P1 12.25
P2 10.20
"TOTAL" 45.70
...
29.1.2018 P0 23.25
P1 12.25
P2 11.20
"TOTAL" 46.70
...
30.1.2018 P0 23.25
P1 13.25
P2 11.20
"TOTAL" 47.70
...
Thank you.
BR
Martin
Or this
Aggr(RangeSum(Above(Sum(Exp), 0, RowNo())), Dim2, (Dim1, (NUMERIC)))
Try this
Aggr(RangeSum(Above(Sum(Exp), 0, RowNo())), Dim2, Dim1)
Or this
Aggr(RangeSum(Above(Sum(Exp), 0, RowNo())), Dim2, (Dim1, (NUMERIC)))
Hi,
thank you.
Unfortunately, no one works.
Would you be able to share a sample to show what you have?
Sorry, I can't. Anyway thanks for your hints.
All we wanted to was to do this in a dummy data... you sample image attached looks like a dummy data with Dim1, Dim2 can't be your real dimensions? You can't share dummy data?
Anyways, I still believe that the expression should work... what do you see when you use the provided expression?
In case, the issue has been resolved, I would suggest closing it down by marking correct and helpful responses.
Best,
Sunny
If all you want to do is limit the Dim2 to the three values P0,P1,P2 then this measure expression should work for you:
Sum( {<Dim2={'P0','P1','P2'}>} Exp )