XL-Reporter : Monthly & Yearly
Hi! Hav anyone tried in getting monthly & yearly values in XL-Reporter?
For current day's detail of sales we can use,
FIG( SO_TaxDate = CurrentDate ), which works good.
similarly if i put
FIG( SO_TaxDate = CurrentMonth )
FIG( SO_TaxDate = CurrentYear )
it is not showing any values, but '0'
how can i get the monthly & yearly values similar to 'CurrentDate' ?
in case of year i hav to go for fiscal year which is frm Apr - Mar
If you filter your column selection by financial period where the Code = CURRENTPERIOD
Then for your year to date column selection you could filter by the financial period where CODE = YTD(CURRENTPERIOD)
I hope this helps, regards