Office 2013 Pivot Table Filters Going Weird

Hi guys,

Hope you can help me.

I moved to Office 2013 today and happy with the change.
One thing I picked up that makes no sense to me at all is with the Pivot Table Filters.

In all previous version, if you had 2 filters You where able to filter on the first values, then the second values would be linked to only what is linked to the first values.

Example:

Soccer, I have a table with all the soccer tournament in the world, with the Tournament, TeamNames, Players & NumerOfGoals.
Say I had "Tournament" on top, then "TeamNames" below it in the FILTER of the Pivot table with the Players in the ROWS and NumOfGoals in VALUES.

In 2007, if I picked ChampionsLeague filters in the Tournament section, the I will only see TeamNames linked to ChampionsLeague.
In 2013, if I picked ChampionsLeague filters in the Tournament section, I still see ALL the TeamNames, regadless of their Tournament...

I'm sure its just a setting I have to change cause if this is a new "feature", its stupid!!!

PLEASE PLEASE help!!!

First of all congrats for getting promoted to upgraded version of Excel.

Yup that is there...But why dont you use dynamic functions to get your summary instead of pivot table.

If you are not comfortable in that, please upload your file here so that one of us can help you with that.

Cheers!!!

Hi,

In this case, you should get a Filter at the TOP, when you click on the Filter Arrow that says Select Field.

You might want to check it out.

And none of the features with Pivot Tables are stupid..

Originally Posted by NeedForExcel

Hi,

In this case, you should get a Filter at the TOP, when you click on the Filter Arrow that says Select Field.

You might want to check it out.

And none of the features with Pivot Tables are stupid..

What our user "xz_LeStat_zx" is trying to say is that, when he select anything in first filter in Rows field, and he looks for corresponding value in 2nd Rows filed however, instead of getting the corresponding value, he sees all value which are there in database (which is now 2013's feature)

Refer the below images

Filter 1.png


Filter 2.png

Not very sure if that used to happen in the previous versions aswell..

Don't recall!

This is not new to 2013. It's the same as it always was. Autofilter dropdowns reflect other filters applied, but pivot table filter dropdowns don't.

Originally Posted by romperstomper

This is not new to 2013. It's the same as it always was. Autofilter dropdowns reflect other filters applied, but pivot table filter dropdowns don't.

Thats exactly what I am saying.. They are the way they were..

Originally Posted by romperstomper

This is not new to 2013. It's the same as it always was. Autofilter dropdowns reflect other filters applied, but pivot table filter dropdowns don't.

Ohh yess...even i was trying to recall as its been ages I worked on lower version of excel

Hi Lestat..


We hope you have got the answer for your query.



Kindly take few seconds to mark this thread as SOLVED and say thanks to the person who helped you by adding *Add Reputation.

Make Use of Slicer so that you don't need to step into the drop down list.

Simply you can select the available names from the slicer view