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 ...
Hello,
Based on the picture you uploaded, when you filtered for Australia and Shipped in columns C and E, the table to the right "folded" hence you're seeing records for Japan. This is how filtering works in Excel when you have two or more Tables in a Sheet tab. If you look to the row numbers, you will see that they are in blue font color.
What you need to do is move the Table to the right to another sheet. Or if you have the new Dynamic Array Functions available in Office 365 Insiders and Monthly Channel (as of today), you can use the Filter function
Based on the picture you uploaded, when you filtered for Australia and Shipped in columns C and E, the table to the right "folded" hence you're seeing records for Japan. This is how filtering works in Excel when you have two or more Tables in a Sheet tab. If you look to the row numbers, you will see that they are in blue font color.
What you need to do is move the Table to the right to another sheet. Or if you have the new Dynamic Array Functions available in Office 365 Insiders and Monthly Channel (as of today), you can use the Filter function
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.
