Forum Discussion
Displaying items with no data
We don't have access to this sharepoint location
How else can I share data?
Just give us a small sample in some format like such:
Column1 Column2 Column3
data1 data2 data3
data4 data5 data6
Or use a file storage service like Box, OneDrive, GoogleDocs etc.
Sales Pro Name Company Name November December January Total
Mary Smith Company 1 1 2 3
Company 2 2 2 4
Company 3 0
The counts represent # of Face to Face calls by the Sales Pro during the month.
The first table (Entities Table) I use contains the name of the Sales Pro and all of their assigned Entities
The second table Activities Table) contains the Entities where there were activities, the dates of the activities and the Sales Pro name.
The Activities Table contains additional activities, such as e-mail, phone call etc.
I want to be able to show a Sales Pro's full portfolio and who they have had a face to face call with and who they haven't.
I also need to count how many Companies Mary Smith has not had a Face to Face call with.
Hi LMorman,
The above table is your expected result, right? Could you please also post sample data of your source tables?
Thanks,
Lydia Zhang