Forum Discussion
Pivot Table help to show dates next to names with Grand total (i.e Aimee 4/2/2021)
Do you mean to show list of all related to the name dates (unique dates)?
SergeiBaklan Yes, I believe so. Since today is 4/5/2021, I should be able to select todays date but still have the grand total for the month of April. If that makes sense.
Sorry, still not sure I understood correctly. So, you would like to select in filter or by slicer concrete date (not the period, e.g. from Jan to Jun 2021) and receive in Grand Total total number of dates for the year/month of the selected date. Against each name it shall be the list of dates for this name for the selected year/month, correct?
@ Sergei Baklan - Correct! Against each name it shall be the list of dates for this name for the selected year/month and day. So in the PivotTable Fields. How do I add in the 'Dates'? At the bottom in the 'Rows' section, it currently just has the names 'UWC'.
