Oct 16 2019 09:44 PM
I'm working on a volunteer project which sums the population in a hierarchical fashion: Region, District, Division, Village etc. Each higher level contains the population numbers of levels below it. When I select District for example, I want the names and numbers for each of the districts across the country, without the long list of associated granularity from levels below. Or if its a lower level, the data without being nested in higher levels. I have to open the field list each time now and select or deselect the levels. I also have replicated the pivot table several times and selected a different level in each table. But I am not the ultimate user and multiple tables or opening the field list does not work well for the end user. Thanks for your help.
Oct 18 2019 12:30 AM
@RonCh11 Here is an abbreviated example file that of the pivot table to illustrate what I would like to achieve.