Forum Discussion
Need Help with Tables and Filters
Hi everyone, I am stuck in the different results from the same dataset in tables. For example, when I filtered "Country" to "Australia", the other table showed “Japan", and the relevant tables ...
Hi,
Thank you for your reply. I just uploaded the file, could you please take a look at it? Thank you.
Thank you for your reply. I just uploaded the file, could you please take a look at it? Thank you.
It's exactly what I expected. When you filter Australia and Shipped in the first table you simply hide the rows that are not Australia and Shipped. Then the rows in the other tables are also hidden. I guess you can make the summaries you want with pivot tables as demonstrated in the attached workbook.