mardi 24 février 2015

Excel - How to reference pivot table with filter

I build a pivot table with types as filter,


I want to create a report by referencing the data in the pivot table by different types.


but the data would change when I change the filter,


I'd like to know how can I keep the data static when referencing the table,


Thanks!


Aucun commentaire:

Enregistrer un commentaire