Hi all,
I am working on a pivot table that has all Sales Reps and Counts the number of call that they've made. It accomplishes this by COUNT of Phone call, COUNT of Zoom meeting, etc. (each its own column)
My columns are : Date / Call Category / Count of each type of Call.
Problem: When I filter by date, anyone who has no communication on that date disappears. I want them to remain with either a null or zero next to their names. I already clicked on 'properties --> general --> fill empty cells with zero, but that only fills empty cells with zeroes for the reps that have other cells filled, the other reps still don't show.
Thanks in advance for your help!