I have a table of employees and some of their information. Long story short, I have had to make each employee into their own little table to filter through other information (when their review is due, did they meet their last one, what department are they in now) etc., but the only problem is the original table’s filters no longer work.
How can I make the original table also read the information that’s within the mini tables? E.g., filter all employees by the review due date for August or people working in a certain department. I can do this within each individual table but not the larger one. The columns all match up to the original table but it just no longer reads the mini tables within.