Forum Discussion
Displaying items with no data
I am trying to create a matrix to display a Sales Person portfolio of clients and who they have met with in person, when and who they have not.
Table 1: includes the name of the Sales Person and their assigned companies
Table 2: Name of the Sales Person and the companies the have contacted and the date. There are multiple types of contacts in the table, i.e. e-mail, in person, phone call etc.
My issues is when I filter to show just the in person acticities, I lose the names of the companies where there have been no activities.
14 Replies
Yes, yes you would.
Hi LMorman,
Would you please share sample data of the above two tables and post the expected result? Besides, we need to know that how you filter the table visuals.
Thanks,
Lyida Zhangwhat is the best way to share the data. I am having issues with copy and paste from Excel into the relply box
When you filter, the data that doesn't have corresponding values for your filter/slicer will not be shown. That is the point of a filter. Maybe I am not understanding your question?
We don't have access to this sharepoint location
