Forum Discussion
One table puts multiple filters on another table
Ragnarock1982 Thanks for the response! However, I do think you misunderstood me and rereading my response I understand why. I don't have a chart at all. I'm using two table visuals. When clicking on one of the rows in the GroupBy table that I explained above it filters the Details table for all of the records for which that specific salesman had sales. Here is another, hopefully more clear, example:
GroupBy Table
Salesman Date Product Category
Bob Smith 1/1/2018 Pie
Bob Smith 1/1/2018 Cookies
Jane Doe 1/1/2018 Pie
Jane Doe 1/1/2018 Cookies
Bob Smith 1/2/2018 Pie
Bob Smith 1/2/2018 Cookies
Jane Doe 1/2/2018 Pie
***And so on I think this gets the point across***
My Details Table looks like this
Salesman Product Category Date Sales Amount Customer
Bob Smith Cookies 1/1/2018 $10 Cookie Monster
Jane Doe Pie 1/1/2018 $5 Joe Jackson
Jane Doe Cookies 1/1/2018 $7 John Thompson
Bob Smith Pie 1/1/2018 $13 Jose Gutierrez
Jane Doe Pie 1/2/2018 $5 Brad Washington'
Bob Smith Cookies 1/2/2018 $20 Sarah Smith
So when I click in my GroupBy Table right now it only filters my detail table by Salesman. So if I clicked the first line (in my groupby table) it would give me all of the Bob Smith rows in my Details Table (the 1st,4th, and 6th lines in my example). However, what I want my GroupBy Table to filter for in my details table is when I click the first line (of GroupBy) to filter for all of the lines where Bob Smith made sells on 1/1/2018 in the "Pie" product category. So if I clicked the first line of my Group By table it would filter the Details table to where I would only see line 4 in my detail table (since this is the only line in my detail table where Bob Smith on the date 1/1/2018 sold something in the "Pie" product category). Let me know if I can elaborate more on this, and again thanks for the reply.
Hi Anonymous
Could you share an example of your data?
I can't reproduce your problem.
As tested, if i add "Salesman", "Date" and "Product Category" from the "Details Table" in the table visual, it will show the distinct values, it groups the table by these columns.
Then click on one row, it will show rows as selected.
Best Regards
Maggie