Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I want to show previous previous month sale
The following expression is for previous month and tried using -2 instead -1 this is showinng the previous month sale only
Any help regarding this
sum
(
{<
CalendarMonthAndYear={'$(=DATE(Max(CalendarMonthAndYear)-1,'MMM YYYY'))'}
>}
sales_total
)
Regards,
Kishore.
Try like:
sum
(
{<
CalendarMonthAndYear={"$(=DATE(AddMonths(Max(CalendarMonthAndYear),-2),'MMM YYYY'))"}
>}
sales_total
)
Try like this
=SUM({$<MonthName=, [Posting Date]={">=$(=MonthStart(max([Posting Date]),-2))<=$(=(addmonths(max([Posting Date]),-2)))"}
>}[Gross Sales Amount])
Try like:
sum
(
{<
CalendarMonthAndYear={"$(=DATE(AddMonths(Max(CalendarMonthAndYear),-2),'MMM YYYY'))"}
>}
sales_total
)
Thank you Tresesco