2015 display 903K wrong , How to make it display 110K ?

[paulyeo11]

Hi All

My scatter chart 1 expression display wrong value.

Sum({$<year={$(=Max(year)), $(=Max(year)-1)}, Month = {"<=$(=max({<year={$(= max(year))}>} Month))"} >} sales)/1000

2015 display 903K wrong , How to make it display 110K ?

My Table 1 display correct value.

Paul

[paulyeo11]

My QV Doc

[Kushal_Chawda]

write this expresion

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/$(Columndim89)/1000

[paulyeo11]

Hi Kush

Thank you for sharing.

This chart i expect it to show the figure same as table .

Meaning it should show the sales for 2016 YTD compare with 2015 YTD.

Paul

Sent from my iPhone