Set Analysis Errore

[#1]

Hi,

i want to show the sales of current month and last month.am getting a syntax errore plz help me .

[settu_periasamy]

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..

[jolivares]

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.

[#4]

thanku juan,

iit's working fine but by defaul it should show max sales and max-1 sales

[settu_periasamy · Accepted solution]

Hi,

Check the Attachment.