Acumulative Expresion

[#1]

Hi,

I have this entry data

Month	DataType	Value1	Value2
01	R	10	1
01	O	12	1
02	R	11	1
02	O	15	2

and I would like to obtain this result

Month	02		01
DataType	R	O	R	O
Value1	21	27	10	12
Value2	2	3	1	1

where the rows Value1 and Value2 are acumulative expresions

Value1 = sum(Value1) = Value1 of Month 01 + Value1 of Month 02

Value2 = sum(Value2) = Value2 of Month 01 + Value2 of Month 02

I have tried doing this using an expression like  RangeSum(below(sum(Value1), 0, NoOfRows())), but there is a problem with the dimension DataType.

so actually the result obtained is this

Month	02		01
DataType	R	O	R	O
Value1	11	15	10	12
Value2	1	2	1	1

Any suggestions?

[Gysbert_Wassenaar · Accepted solution]

See attached example. See this document for a bit of explanation about the AsOf table.

[#3]

Thank you very much Gysbert. It's not just a correct answer, the proposed link is very useful.