cumulative sales..

[prabhas277]

Hi,

If you make selection on any date , it should show cumulative sales from month start till the selected

date.How will you do it?

[MK_QSL · Accepted solution]

You can do it by Set Analysis...

Considering that the date field name is InvoiceDate and you also have InvoiceYear, InvoiceQuarter, InvoiceMonth, InvoiceWeek....

=SUM({<

               InvoiceYear=, InvoiceMonth=, InvoiceQuarter=, InvoiceWee=,

               InvoiceDate = {">=$(=Date(MonthStart(Max(InvoiceDate))))<=$(=Date(Max(InvoiceDate)))"}

          >}Sales)