Can somee one assist me how to create expanding and collepsing tree dimension in pivot table
Add two dimensions for Region and Country to your pivot table. Then you can expand and collapse the Region dimension.
I got the solution. I added both column and enable the indent mode to get the proper visualization.
Retrieving data ...