How to Select Days for Subtotal

[Anonymous]

I have a list of customers with sales data, and i only want to select certain days of the month as a subtotal.  The MTD Total continues to show in the Straight Table Total not just the the subtotal of the five days that I selected.

[isingh30]

Can you share your data or app? On what criteria/basis we gonna select those days?

[shiveshsingh]

please elaborate the requirement..sample app?

[ajaysingh285]

Hi Patrick,

Please find below the expression:-

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)

Regards,

Ajay

[shiveshsingh]

For this, you need to define the Datenum field too like floor(Date_Field)

[Anonymous]

Days selection is based on those days in the week.  The issue is that the column totals that appear after selecting those days doesn't change regardless of what or how many days are selected.  The column totals remain the month-to-date totals.

[Anonymous]

[isingh30]

Try like this -

Sum({$<Month = {Jan},[Days of Month] = {1}>} Sales)

Let me know.

[Anonymous]

Did not work

[isingh30]

Please replace sum with only & then try.