I want to calculate last 4 any weekdays total sales.Based on filter max date. Example: I have 2 filter 1. Date range(From -To) 2. Week Day(Like Mon,Tue Etc.)
I need total sales for last 4 Monday or Tuesday (as per above filter ).And Last 4 weekdays will be calculated based on To-date in filter. Like To-date is 31-Dec'18 then last 4 Tuesday will be 4,11,18,25 Dec. Thanks in advance for the help.