Forum Discussion

H_insight's avatar
H_insight
Helper V
3 years ago
Solved

Custom Hierarchy

Hi All,

 

I am trying to achieve the below hierarchy in PQ, but not getting much success. Any chance of help?

 

Expected outcome:

 

Sample file link.

 

Many thanks

Need Help
  • bharat_kumar's avatar
    bharat_kumar
    3 years ago

    Hey
    I have tried the same and achieve the hierarchy you have mentioned.
    please find the Screenshots for your reference.

    Let me describe you the Applied Steps:

    1. Unpivot the Type column
    2. Pivot the value column by keeping Attribute in value dropdown.
    3. Use Headers as First Row.

    4. Remove the Bottom row (1).
    5. Rename the Column names as per your levels,
    6. Sort the columns as required.

    Please like the solution if you got success.

3 Replies

  • bharat_kumar's avatar
    bharat_kumar
    Regular Visitor
    3 years ago

    Hey
    I have tried the same and achieve the hierarchy you have mentioned.
    please find the Screenshots for your reference.

    Let me describe you the Applied Steps:

    1. Unpivot the Type column
    2. Pivot the value column by keeping Attribute in value dropdown.
    3. Use Headers as First Row.

    4. Remove the Bottom row (1).
    5. Rename the Column names as per your levels,
    6. Sort the columns as required.

    Please like the solution if you got success.