I have one table with all Region,Country,State and values as below
And I want to show these in hierarchy as below in pivot table with expand and collapse, could someone let me know to sort this
As shown in first table above,data is in single field. So just want to know how to convert this data to different levels to show in pivot as shown in second table
Do you have a field to differentiate the country, region,state. If not can you create it.
If above things not going to work then use wildmatch functions to create this field in backend like...
if(wildmatch(Region,'India','Pak',......) ,Region) as Country
if(wildmatch(Region,'Europe',......) ,Region) as Field2
Thank you for the reply.
Let me put my requirement in below manner.
Let all values (APAC,Europe,India,Pak..) in one column in pivot table but initially only APAC,Europe should be shown. But when I click on a button I should show the India,Pak , England and click on another button should hide India,Pak , England values
My requirement is to show the all values( (APAC,Europe,India,Pak..) in single column and
a. Initially show only APAC and Europe
b. Place button to show/hide the (India,Pak,England ) row values
Please let me know if this is possible or not in pivot table