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?
I would like it to filter and count each date string. In the file, if I clicked on the filter icon next to Row Labels, it should show each date string in April and under it list the dates that I can select which one or select all: 4/1/2021; 4/2/2021; etc. to show next to the names.
If like this
shall we show only one date in This Date; or don't show them at all and use only slicer; or repeat the date as above?
You may use such DAX measure
This Date:=IF ( HASONEVALUE ( Range[UWC] ), CONCATENATEX ( VALUES ( Range[Date] ), FORMAT ( Range[Date], "mm/dd/yyyy" ), "; ", Range[Date] ), "" )to have result as
Please check attached.
- Only show one date.