Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
My QV Doc
write this expresion
SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/$(Columndim89)/1000
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