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
|