Hi, I have a request, basically is amount accumulate per month, I was investigated and found the function running-total, I was allocated to:
ACCUM = running-total([amount] for [city])
I have got:
Amount ACCUM
Spain Madrid Jan 20,128 20,128
Feb 20,329 40,457
Mar 20,812 61,269
Valencia
Jan 55,682 55,682
Feb 52,108 115,469
Mar 65,020 187,836
Toledo
Jan 35 35
Feb 46 81
Mar 1 82
Overall 234,161 481,039
Venezuela Caracas
Jan
Feb
Mar
Valencia
Jan 7,679 63,361 I'd have 7,679
Feb 7,347 122,816
Mar 8,965 196,801
Barquisimeto
Jan
Feb
Mar
Overall 23,991 382,978
On the SECOND Valencia city, the calculate is: spain.valencia 55,682 + Venezuela.valencia 7,679 = 63,361, it's bad, should be 7,679. :o
Please, someone can I help me, with amount accumulate or it raise
Additional information. Properties
• Classes : Crosstab member cell(calculated)
• Solver order: it's setted
• Aggregate function: Automatic