Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a below expression which will plot every month of the stock status.
money(
fabs(rangesum(above(
Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}
, month = ,year=>}[Amount]/1000/$(ColumnDim98))
,0,rowno()))
)
, $(vMoneyFormatK_GL))
Now i only want it to plot only starting from 2013 Jan.
May i know what should i modify the above script ?
Enclosed my QV Doc
Any one can help me ?