Accumulation - outer/inner dimension

[mato32188]

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

[sunny_talwar]

Try this

Aggr(RangeSum(Above(Sum(Exp), 0, RowNo())), Dim2, Dim1)

[sunny_talwar · Accepted solution]

Or this

Aggr(RangeSum(Above(Sum(Exp), 0, RowNo())), Dim2, (Dim1, (NUMERIC)))

[mato32188]

Hi,

thank you.

Unfortunately, no one works.

[sunny_talwar]

Would you be able to share a sample to show what you have?

[mato32188]

Sorry, I can't. Anyway thanks for your hints.

[sunny_talwar]

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

[petter]

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 )