asked
for any given Week(s) how many days from those weeks account/store got products and how many days in those weeks account/store sold out those products
I need to make changes in SSRS report which has DateEndWeek and account/store data as a parameter, also it has each day of week (Mon thru Fri) columns when that account get product and columns for each day of week when that product were return . I need to count for any given DateEndWeek (it's may be one or more week(s)) how many days from those weeks account/store got products (days, not value of product) and how many days in those weeks account/store sold out those products. My second point should be : from that amount of week(s) I need to count Mondays when account/store got products and in how many Mondays product was sold out . As example in two DateEndWeek will be 2 Mondays, each Monday can get product or not and each Monday it can be sold out or not.
13 People are following this question.
