nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Hi, I have a table (not pivot) that contains many columns but for the purpose of this I will say two. Col A and B.
In A I have supplier and in B I have expense.
Firstly i filter by supplier to show all items purchased by the said supplier. Secondly I want to do a top 10 filter on the expense column. I do this and it works, however, it still takes into account all the filtered out suppliers, resulting in me seeing on the visible parts of the top 10. For example, I may see 6 results with the other 4 as the filter is still taking into account the filtered out suppliers..hope you can help, thanks in advance.
In A I have supplier and in B I have expense.
Firstly i filter by supplier to show all items purchased by the said supplier. Secondly I want to do a top 10 filter on the expense column. I do this and it works, however, it still takes into account all the filtered out suppliers, resulting in me seeing on the visible parts of the top 10. For example, I may see 6 results with the other 4 as the filter is still taking into account the filtered out suppliers..hope you can help, thanks in advance.
