Accumalative Results on a complex Tab (Pivot)

[Anonymous]

Hi,

I have a problem to cumulate result on a tab.

Check screenshot and my application.

On the line L3 Y2D i want to sum the data of L3 :

In january : 6

In February : 6 + 2

In March : 6 + 2 + 2

In April 6 + 2 + 2 + 2

Thank you very much,

Regards!

[Anonymous]

Up!!

[#3 · Accepted solution]

Hi Emilien,

Look at the file attached.

Your intuition was almost right, but in this case you want to accumulate Columns instead of Rows, so you have to use Before() function instead of Below.

Example :

RangeSum(Before(TOTAL sum(TARGET.TARGET_L3),0,ColumnNo(TOTAL)))

Regards,

Benoit

[Anonymous]

Merci Benoit ça correspond exactement à ce que j'attend.

Bonne journée!