Get filtered data with index and match|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello,

I would appreciate it if someone could help me with this question. I've created a very simple example to explain it.

I have raw data that comes from a database tool. The colums are not organized as desired so, I want to organized them in other tab and, in addition, I want slices to filter that the information.

Tab raw data:

• I copy paste the information of my database tool in a table (with format table so that I can add slicers).

Tab Dashboard:

• With Index and Match, I can get the information with the columns ordered as desired.
• I paste the slices above this information.

When I filter the data with the slicers, the data filtered is that of the raw data tab, not the data in the tab dashboard.

Is there any way that I only get the data that is not hidden?

Thanks in advance,

Cristina