PowerPivot column dropdown filter?

[Damyan]

Hello,

I'm quite new to using power pivot in excel and I experience the following problem. My data consists of brands, tv investment, TRPs and GRPs (these are tv audience measurments), TV channels etc - each one in a separate column. What I want to do is a drop down menu of TRPs/GRPs/TV investment and this menu to filter each pivot table in the sheet and show me the selected value. In other words - I want to avoid having identical tables - one for brands and TRPs, one for brands and GRPs, one for brands and TV investment. Can anyone help with this, please? I can explain further if was not clear enough.
Thanks in advance!

[JeteMc]

Hello Damyan and Welcome to Excel Forum.
From the description it would seem that the way to get the output desired is to select and deselect TRPs, GRPs and TV investment in the field list, I can not envision how it could be done using a filter or slicer.
Perhaps if you could upload a desensitized sample of the data someone will have a differing opinion. To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.