Show single field values in hierarchy

[suren946]

Hi All,

I have one table with all Region,Country,State and values as below

Region	Value
APAC	200
APAC	200
Europe	300
India	100
Pak	100
England	300

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

APAC			200
	India		100
		Andhra	50
		Telangana	50
	Pak		100
Europe			300
	England		300

[miskinmaz]

Hi,

Assuming that you already have the data of hierarchy, use pivot table as chart type.

[suren946]

Hi,

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

[miskinmaz]

Hi,

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

..etc

[suren946]

Hi Miskin,

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

[jyothish8807]

Hi Surendra,

Please refer the sample attached.

Br,

KC

[suren946]

HI Jyothish,

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

[jyothish8807]

May be this:

Give it a try.

Br,

KC