multilevel drill down in excel 2013

[phani1986]

Hello guys,

I am working on Excel 2013, I have sample table data that shows populations based on cities, the columns in the table are continent,country,city, population.

what i want is :

initially show continents and populations(sum by countries in the continent)), when i drill down by double clicking on population(sum) for a particular continent, I need countries of the continent and populations(sum by cities), and when i furthur drill now by country, I need all cities and their population in that country.


I have seen something like a quick explore option online, but I dont get a quick explore button when i click on grouped continent in my table.

Any help is appreciated.

Thanks,

Phani.