| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table filter list - listing irrelevant subcategorys
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table filter list - listing irrelevant subcategorys
On Tuesday, July 1, 2014 5:04:14 PM UTC+5:30, wrote:
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Listing of Pivot Table in a worksheet | Excel Discussion (Misc queries) | |||
| Creating a list of job numbers, missing out irrelevant items | Excel Worksheet Functions | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Pivot table filter list doesn't refresh | Excel Programming | |||
Hybrid Mode
