3 Replies Latest reply: Apr 25, 2015 6:34 AM by PAUL YEO RSS

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

    PAUL YEO

      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