Accumulative Field

[ecabanas]

Hi all,

I have a table with the number of lines of each product. = Count(line)   Dimension ItemId

I wanna know the accumulative number of lines in number and %

Any suggestion?

Many thanks

[sunny_talwar]

For Accumulation try using Full Accumulation option within the expressions tab:

For % Accumulation try full accumulation + Relative checked on expression tab:

[ecabanas]

Hi Sunny

I already tryied this but did not work

[sunny_talwar]

Would you be able to share a sample?

[ecabanas]

Here it is

Many thank's

[sunny_talwar · Accepted solution]

Ended up using expressions to do the accumulation

1) RangeSum(Above(TOTAL Count(SalesId), 0, RowNo(TOTAL)))

2) RangeSum(Above(TOTAL Count(SalesId), 0, RowNo(TOTAL)))/Sum(TOTAL Aggr(Count(SalesId), ItemId, name))

[ecabanas]

WOWWWWWW

Bravo!!!

Many many thank's