Hello,
I'm working on a pivot table with the rows representing dates and the columns representing events. I have a couple of days where no events occurred and thus there are now rows for this date in the original datatable. The result is that the pivot table does not have a row for this date. I would like to be able to have the pivot table include a row for these dates with no events, but just mark it as 0. Is this possible?
Thank you. If more clarification is needed, I'm happy to provide.
I'm working on a pivot table with the rows representing dates and the columns representing events. I have a couple of days where no events occurred and thus there are now rows for this date in the original datatable. The result is that the pivot table does not have a row for this date. I would like to be able to have the pivot table include a row for these dates with no events, but just mark it as 0. Is this possible?
Thank you. If more clarification is needed, I'm happy to provide.
