HOW WILL CREATE TREE STRUCTURE IN PIVOT TABLE

[#1]

is it possible tree view   in pivot table

A

   D

   E

B

C

  E

LIKE ANY ONE PLEASE HELP ME ..

Thanks & Regards

Ravi G

[adamdavi3s · Accepted solution]

Do you have example data?

To my mind this is exactly what a pivot table is intended for?

[#3]

Kp1  CHILD

A       B

         C

D      F

        G...

but I want

Path

A

  B

  C

D

  F

  G

in pivot table please help me!