Your Idea on improving this Pivot table (revamp or redo). Suggestions and Ideas.

[xcelRaj]

Hi,

So the idea is to improve the existing pivot table i have now. Basically there is a filter with which I filter the countries. Then when I filter the countries, there is another filter that I need to select to show values related to that. For example :

Filter : Country : US/Europe/Asia

Filter : Models : iPhone/Samsung/LG/Blackberry/HTC.

Data (Rows) : Number of Users
Data (Rows) : Number of Male Users
Data (Rows) : Number of Female Users


Like this I have 5 different countries and 5 different models (same for all 5 countries), the data (rows) are same for all the models and all countries. So basically I want all 5 countries with their respective Data(rows) to appear when I select only the country. In the Pivot Table I have now I am forced to select the Models individually. I would like to have them appear one below other with their Data(Rows) like a tree structure.

Thanks a ton for your help and suggestions in advance.

It would be incredibly helpful for me.

[oeldere]

Please mark this duplicated post solved.