Shouldn't pivot table filtering follow related Data Table filter?
Posted on 2014-02-26
Hello - I set up a data table on a worksheet, and then based a pivot table off of it.
When I filter the data table, the pivot table refreshes, but with absolutely no relation to the data table filtering!
What have I got wrong?