7 Replies Latest reply: Jan 24, 2018 10:18 AM by Petter Skjolden

# Accumulation - outer/inner dimension

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

• ###### Re: Accumulation - outer/inner dimension

Try this

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

• ###### Re: Accumulation - outer/inner dimension

Or this

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

• ###### Re: Accumulation - outer/inner dimension

Hi,

thank you.

Unfortunately, no one works.

• ###### Re: Accumulation - outer/inner dimension

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

• ###### Re: Accumulation - outer/inner dimension

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

• ###### Re: Accumulation - outer/inner dimension

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

• ###### Re: Accumulation - outer/inner dimension

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 )