I'm trying to work out how to calculate the number of consecutive days that a positive value is shown in a row. My data is summarised in descending date order in a pivot table. Any ideas?