I'm trying to create a Dashboard with slicers and pivot charts from a pivot table.
I'm struggling with creating filters from the different columns I have in my pivot table. They are in the "VALUES" section from the pivot property.
I would like to do 2 things mostly:
Be able to filter from the columns (display only one of the column, all of them, etc...)
Also, is it possible to add data from a second table to a pivot chart? I would like to display the average % without it being affected from the filtering (so I can compare).
Attached you will find what I have so far : https://ufile.io/0wgxo
I'm struggling with creating filters from the different columns I have in my pivot table. They are in the "VALUES" section from the pivot property.
I would like to do 2 things mostly:
Be able to filter from the columns (display only one of the column, all of them, etc...)
Also, is it possible to add data from a second table to a pivot chart? I would like to display the average % without it being affected from the filtering (so I can compare).
Attached you will find what I have so far : https://ufile.io/0wgxo