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 !

[edg_baltazar]

Hello! , To do this you only need to use Set Analysis ... take a look to the qvw that i attach, for a different TypeData value you only have to create a new expression, use the MU or FC expression making a change in the set analysis!

Total expression:

=sum(Amount)

MU expression:

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

FC expression:

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

[zarmoton]

Hello,

Thk you very much  Edgar for your help

But this is not exactly what i'm looking for.

First, for 2012-2, i want to see the cumulative data from beg of the year (ie 2012-1 + 2012-2)

and second, i would like to have a list box selection with the filed TypeData.

and Select the typedata that i want to chart, with the format that i have described in my introduction.

Regards,

[edg_baltazar]

In the expressions tab , select the expression and check 'Full Acumulation'... this will make the accumulation , with the set analysis example that i explained to you in the previous comment you could add a listbox of TypeData and select the TypeData that you only want to Chart. Regards!

[zarmoton]

thank yu

For this point : "First, for 2012-2, i want to see the cumulative data from beg of the year (ie 2012-1 + 2012-2)" => It's correct, with Full Accumulation it's working perfectly

Now for my second point, "second, i would like to have a list box selection with the filed TypeData.

and Select the typedata that i want to chart, with the format that i have described in my introduction"

If i add a list box, and i select only one Typedata (for example FC), the line FC should be equal to the line "Total"

In your example, the line MU and FC is always display in the chart , whatever is the selection

Imagine in the data i have FC, MU, and PTR, when i select only FC and PTR, i want the line FC, PTR, and FC+PTR

If i select all FC, MU, and PTR,  i want the line FC, MU , PTR, and FC+MU+PTR

if i select only FC, i want to see only one line FC (total = FC in this case)

[edg_baltazar · Accepted solution]

Finally I understand you and I could do it , review the .qvw that im attaching (I've modify somethings) , the only think you need to do is to add one more dimension to the chart, but it has to be a calculated dimension, and you only need the expression Sum(Amount) , its very easy! , please let me know if this help you.

Regards!

[#7]

Dear Edgar,

can you please write down here the formula for the calculated dimension, sadly I cannot open qvws of other ppl...

Many thanks!

[zarmoton]

here is the formula in dimension:

=

if($Field='TypeData',TypeData ,'TOTAL')

and in Expression a simple :  sum(Amount)

regards,

[#9]

Thank you for your prompt help!

But it is nort working out, nothing changes when I insert that calculated dimension.

One question: do you have already a pre-filled 'Total' field?

thanks!

[zarmoton]

do you have already a pre-filled 'Total' field? > No