Hi,
I have a powerpivot spreadsheet set up - in the pivot table I have "visit date" as row labels and "visit time" as column labels.
I have a slicer which is "booking date" - when i select a value on this the pivot table updated but only shows values where a booking has been made - is there any way I can show all visit dates and times (like a calendar view)?
Thanks.
I have a powerpivot spreadsheet set up - in the pivot table I have "visit date" as row labels and "visit time" as column labels.
I have a slicer which is "booking date" - when i select a value on this the pivot table updated but only shows values where a booking has been made - is there any way I can show all visit dates and times (like a calendar view)?
Thanks.