Using Data FIlter Source Box to Update Table Filter
Jun 30, 2020 2:12 PM(92 views)
I am trying to use a bar graph as a source to update a global table data filter and am having trouble figuring it out. Why would I want to do this you might ask? Well, I have a primary table called A with two linked summarized tables B and C off of the primary A. I would like the user to be able to choose a bar from a bar graph which was created in B and have it update the graphs that exist in C - all linked through A.
When summarizing you can link back to the original dataq table but not cross reference from one summary table to another. You would need any kind of index to know what belongs to what.
That said, usually in a summary table you have a grouping variable. You can use this grouping variable to virtually link to the other data tables and then you should be able to filter and track the filter selection all the way to your final table and plot respectively.