Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)