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