Forum Discussion
get Pie Chart to Filter Table
MFelix I suppose I could makes you some sample tables of what the data looks like. How can I get them to you / attach them to the OP?
You can add them to the post as text a e-mail to a onedrive/we tranfers file or send me a Private message with the information.
Regards,
MFelix
*edited OP again*
MFelix I just made up some sample data, and a new PBI Report to go with it so that I can post scrnshts directly from there.
Ok, so technically there is a third table involved here, listing employees and their attributes. I didn't think it was necesary, but I might as well include it.
As you can see, site "ownership" is determined by INITs, but the owner may not necesarily be the person who calls their site. You can see in the screenshot how they are related.
Sites table
SiteID SiteName inits O Mkt D Mkt Site1 Happy Apple Makers 1 a c Site2 The Most Interesting Man in the World 2 b a Site3 Sheep Sheerers 3 d b Site4 Grub's Grub Restaurant 4 b c Site5 Golum's Precious Finders 5 c d
Calls tableCallID Caller SiteID Date c1 bob Site1 4/1/2018 c2 joe Site3 4/1/2018 c3 sally Site2 4/1/2018 c4 ahmed Site2 4/2/2018 c5 schmidt Site2 4/1/2018 c6 nereese Site1 4/1/2018 c7 juanita Site3 4/2/2018 c8 oscar Site2 4/2/2018 c9 ivan Site1 4/1/2018 c10 joe Site1 4/1/2018 c11 ahmed Site1 4/2/2018 c12 joe Site2 4/4/2018 c13 juanita Site1 4/1/2018 c14 ahmed Site3 4/2/2018 c15 oscar Site2 4/1/2018 c16 sally Site1 4/2/2018 c17 schmidt Site2 4/1/2018 c18 juanita Site1 4/2/2018 c19 oscar Site2 4/2/2018 c20 juanita Site1 4/1/2018 Employees
Employee inits juanita 1 joe 2 ahmed 3 schmidt 4 oscar 5 bob 6 sally 7 nereese 8 ivan 9