Re: Want to show Scheme wise sales for a particular period
Do I understand you correcty?
If you select dates associated to March 2020 then you want Sum(Sales) to be sum of all sales for M001 (even the sales that is not done in March 2020)?
If so, then why do you not want to present M003, hence it does also have an scheme that is related to March 2020? Please explain?
If my understanding is correct then @lironbaram solution using IntervalMatch is a good start, but to solve you non-associative needs you will probably need to adjust your Sum (Sales) with some kind of set analysis.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes