November 16, 2019
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).
- 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,
January 31, 2022