Not all days appear in the dataset…
You may have to force the dataset to have every day in it by forcing the missing days to have a value of zero (0). Check out this topic where we used a left outer join with the calendar as the primary table and the facts (data) as the secondary table: How to show Zeros in the pivot table?
1 Like