How to write an expression to calculate number of sales on first specific weekday (Monday) of month/Quarter?
try something like this using weekday function.
if( weekday(month)='monday', count(sales),null())
if( weekday(month_number)='monday', count(sales),null())
thanks for reply.I want to calculate only for first monday of each month/Quarter.
Try like this
=if(Day(Date) <= 7 and WeekDay(Date) = 'Mon',Sum(Sales))
May be that helps
Retrieving data ...