Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As we can see from the picture above,there are two columns and two lines in the chart.
I have already add two columns and the expressions are used as follows:
ADamount: sum({$<cal_month={"2014*"}>}[AD_amount])/1000
Receiveamount: sum({$<cal_month={"2014*"}>}[receiveamount])/1000
But how to add two lines as month-on-month comparison?
Can't you try using above.
Sum(AD_amount)- Sum(above(AD_amount)) as the MOM Expression?
Use combo chart. Four expressions. In the expression tab, you can select an expression and choose bar/line from display options.
I know it need combo chart. But how to write the expressions?
Can anyone solve the problem?
Can't you try using above.
Sum(AD_amount)- Sum(above(AD_amount)) as the MOM Expression?
Thank you for your reply.
But when I use your expression,it doesn't show any number,why?
Oh, I've modified the expression to:
sum({$<cal_month={"2014*"}>}[AD_amount])/1000/Above(sum({$<cal_month={"2014*"}>}[AD_amount])/1000)-1
And it works.
Thank you very much.
can you mark the thread as 'Answered' please?
Done. Thank you very much.
hi Joy, would you mind share this chart.