Seems easy but ...Chart with cumulative (full accumulation) data and sum of cumulative dimension

[zarmoton]

Hello

I have those data:

Year	Month	TypeData	Amount
2012	1	MU	9
2012	1	MU	1
2012	2	MU	10
2012	2	MU	5
2012	1	FC	2
2012	1	FC	3
2012	2	FC	1
2012	2	FC	2

Can you help me to do this chart like , with cumulative (full accumulation) data in the dimension typedata / year/month, and with a line which is the sum of the diffrent dimension seleced (here in my small example i have only MU and FC, but in reality i have around 10)

Thank for your help !

[#2]

Thank you for he screenshots!

just wondering, how does QV know what to do with the 'TOTAL' field mentioned in the dimensions?

It seems to me that somewhere it has to be coded that 'TOTAL'=sum..... ??

[#3]

I see actually one of the first post of Edgar.

Edgar wrote:

Total expression:

=sum(Amount)

MU expression:

=Sum({$<TypeData={MU}>} Amount)

FC expression:

=Sum({$<TypeData={FC}>} Amount)

So basically it is all a matter of creating as many expressions as the amount of my Sales Groups (in my case) and a Total expression....look a bit intricate to me 😕

[zarmoton]

no , no

TOTAL is just defined in the formula, and because it is just a text file (by opposition to Typedata, which is a field, QV will add a new line with TOTAL as the sum of any Typedata

Hope i am clear.

But why can not you download the .qvw as example (FC-MU-TOTAL.qvw ) sent by Edgar. ??

there is no .qws needed