So I have a list of stores that are called upon sales reps. The sales reps do a check of a demonstration unit each time they visit. Is there a way in PowerPivot if the demonstration unit is not operational to count the number of weeks it has not been operational? I have attached an example of what output I am after.
Ideally I would prefer a solution via Powerpivot but am open to any other suggestions.
Any help would be appreciated.example.xlsx
Bookmarks