Pivot table filter list - listing irrelevant subcategorys

  • Thread starter savij.sreedharan
  • Start date
S

savij.sreedharan

Hi,

I made a pivot table as below,


In row - Country, State, City

In Value - Count of associates.


In pivot list i selected country only India and data displayed will be for india only. but when i click on the State, all states including india are listed.

is there a way to list only relevant subcategory?? in the preceding row label lists?


Regards
Savij Nk
 
S

sduryo

Hi, I made a pivot table as below, In row - Country, State, City In Value- Count of associates. In pivot list i selected country only India and data displayed will be for india only. but when i click on the State, all states including india are listed. is there a way to list only relevant subcategory?? in the preceding row label lists? Regards Savij Nk
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help 1
Rows disappear in pivot table 1
Excel 2007 Pivot Table Question 2
Creating a pivot table 1
Value filter missing in pivot table 3
Count(s) in Pivot Table 4
Excel Data validation for dependent list, VBA/EXCEL 0
Pivot Table Sort Field Help 3

Top