very hard to me please could to help me?

[#1]

Hello,

in the attached file I built a table.

I need to group the balance of amounts by end of month.
For example I traked the Item A I need to show the
total amount ina Pivot chart by Item and month.
I need tobuild this table for all Items.

The result should be:

the amount of Item A at 30/09/2009 is 102
the amount of Item A at 31/10/2009 is 142
the amount of Item A at 30/11/2009 is 142
the amount of Item A at 31/12/2009 is 142
the amount of Item A at 01/01/2010 is 140

Please someone could to help me to solve this case?
Thanks

SLah

[amars]

I don't understood UR problem , but see if the attached one help.

Thanks

[#3]

The correct results I aspected for Item A:

Please the correct results are:

30/09/2009 = 102 (110-8)
31/10/2009 = 142 (110--8+40)
31/01/2010 = 140 110-8+40-2

Slash

[Anonymous]

See if that's what you need.

[#5]

in Jan 2010 the total QTy are wrong... I aspected 140

However I solved By loop ... maybe 🙂 (For loop)

Thanks

Slash

[Anonymous]

Hi Washington,

What he need is your Full Accumulation but then in a pivot table.
Because it needs to be grouped by item. (This way it counts different items togehter)

It must be possible somehow.....

[Anonymous]

I think I found it 🙂

Try:

rangesum((sum(Qty)),above((sum(Qty)),1,(rowno()-1)))

See document.

Let me know if this is what you are looking for ok?