Sales

[#1]

Hi ,

  I want to know the expression for :    Current selected month sales VS previous Years current month sales

Can any one help me out

Thanks in Advance

[ashfaq_haseeb · Accepted solution]

Hi,

go through the attached document.

Regards

ASHFAQ

[tresesco]

Read this : Year-over-Year Comparisons

[its_anandrjs]

Try with

Current sales

=SUM({$<Date2 = {'>=$(=Max(Monthstart(Datefield))) <=$(=Today())'}>}Sales)

Previous Year

=SUM({$<Date2 = {'>=$(=Max(MonthStart(AddMonths(Datefield,-12)))) <=$(=MonthEnd(AddMonths(Today(),-12)))'}>}Sales)

[#5]

Thanks ASFAQ ur suggetion worked thanks a lot friend