Areas in pivot table columns using the same row hierarchy

I am trying to create a Pivot table in which the columns value are different but they should be linked to the same row hierarchy.

For example:

Excel.jpg

In the above image, you can see that the there are two different columns in Category A and category B but the left side row hierarchy remains the same. ANy suggestions on how to do this in excel? If I am not clear, please let me know what more details to ask for.

Hi & welcome to the Forum.

Please post a sample template of your workbook in excel format rather than image using "Go Advanced" option. You may choose to delete the confidential information in the file before upload, if any.