Select first working days of selected months

[adamjwchen]

Hi,

I have a date column list all date of a year and I have a column marks each date is working day or not. I would like to make a filter to select first x working day of each month, is this doable?

[sunny_talwar]

May be like this

LastWorkDate(MonthStart(Max(Date)), 1)

[adamjwchen]

What I try to establish is I can input value 10 and then first 10 working day of each month are selected. so all other data are calculated automatically.

[sunny_talwar]

Do you have a sample you can share?

[adamjwchen]

Here is the sample.

Right now I can select workingDay "Y" to calculate working day sales of each month.

but  what I want to achieve is to calculate sales$ of first X working day of each month.

[adamjwchen]

posted

[sunny_talwar]

Try this

Sum(Aggr(If(Date <= LastWorkDate(MonthStart(Max(TOTAL <Month> Date)), vFirstNWorkingDays), SALES$), Month, Date))

Or this

Sum({<WorkingDay = {'Y'}>}Aggr(If(Date <= LastWorkDate(MonthStart(Max(TOTAL <Month> Date)), vFirstNWorkingDays), SALES$), Month, Date))

[antoniotiman]

Hi Adam,

see Attachment.

I assume x = 10

Regards,

Antonio

[antoniotiman · Accepted solution]

New Attachment (TOTAL Corrected)

[adamjwchen]

Antonio,

Your sample is helpful!!