Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Plez I need urgent help to find the quaterly sales of the country. I did the following things,
Year(OrderDate)as OrderYear,
year(OrderDate)& month(OrderDate)as MonthYear,
Year(OrderDate) & Ceil(Month(OrderDate)/3) as YearQtr,
RequiredDate,
any link or website with detail of edit script will be more welcome
thank you
'Q' & Ceil(Month(Date)/3) as Quarter,
Dual('Q' & Ceil(Month(Date)/3) & '-' & Year(Date), Year(Date) & Ceil(Month(Date)/3)) as QtrYear,
Date(MonthStart(Date), 'MMMYYYY') as MonthYear
Try that. Replace "Date" with "OrderDate"
'Q' & Ceil(Month(Date)/3) as Quarter,
Dual('Q' & Ceil(Month(Date)/3) & '-' & Year(Date), Year(Date) & Ceil(Month(Date)/3)) as QtrYear,
Date(MonthStart(Date), 'MMMYYYY') as MonthYear
Try that. Replace "Date" with "OrderDate"
Thanks you so much jpapador.Really appreciated.