Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ?

[paulyeo11]

Hi All

How to i hv below working expression , which is working fine :-

money(

sum({$<           year=,          month=,           MonthSeqNum = {"$(= '>=' & only(MonthSeqNum-12) & '<=' & only(MonthSeqNum))"} >}  Amount*-1/$(ColumnDim98)/1000)

, $(vMoneyFormatK_GL))

How it display line chart of individual expense items.

Hope some one can help me make the chart1 to display overall total expense , by change the multiple line chart1 to single line chart or stack line chart. ( same as Table 1 total row amount , display at chart 1.

Paul

[paulyeo11]

Enclosed my Qv Doc

[MarcoWedel · Accepted solution]

Hi,

maybe like this?

hope this helps

regards

Marco

[paulyeo11]

Thank you very much it work fine now. i need to select the stack bar on the left.