Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i want to show the sales of current month and last month.am getting a syntax errore plz help me .
Hi,
I think your date format is not proper, try to change it like
[Month Year] : Date(Date#([Month Year],'MMM YYYY'),'MMM YYYY') as Month Year
Check the attachment, may be helps..
First take care with the field [Month Year], it don't have a date format so is convenient that you give it the right format in the script.
thanku juan,
iit's working fine but by defaul it should show max sales and max-1 sales
Hi,
Check the Attachment.