difference in Combo chart as line

[UserID2626]

Hi,

I need to get the difference between two dates as line in combo chart

i.e, if i select month feb-2018 combo chart should display feb 2018 data in day wise as bar and line should be difference of feb2018 - jan2018 as day wise.

But I am getting difference as zero when i try to subtract Feb-01,2018 & jan-01,2018.

How to get the difference as daywise in line without using inline script.

Sample attached

Thanks!!!

[ChiragPradhan]

Hi,

Use this expression for your Difference measure -

if(RowNo(Total)=1, Sum(Amount), Sum(Amount) - Above(sum(Amount)))

If you do not wish to show a total for the first month, just use 

Sum(Amount) - Above(sum(Amount))

Regards

Chirag