1

Is it possible to create a pivot table with multiple headers, and each header has multiple subheaders? I've been trying to figure out but couldn't find a way on how to do it right.

This is my current table (raw data)

enter image description here

This is what I want to see in my pivot table.

This is my current table

But instead, it produces this result enter image description here

enter image description here

Hope you could help me out. Thanks in advance.

Improve this question
2
  • 1
    In a word, no, at least not with your data structure. You'd need three columns: Department, Type (desktop/Laptop) and then the Item name. Commented Feb 26, 2020 at 11:22
  • I’m not understanding the delta from what you want. It looks like if you turn off the grand totals on rows and columns you have a perfect match to what you want. What am I missing? Commented Feb 27, 2020 at 0:30
Related questions
1
Pivot Table VBA Macro with Headers That Change
6
excel pivot table - multiple columns
2
Pivot Table with multiple rows all having the same level hierarchy
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.