Forum Discussion
Pivot Table help to show dates next to names with Grand total (i.e Aimee 4/2/2021)
How do I have the dates show next to the names with the total number next to date and have Grand Total for all?
15 Replies
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?
