0

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.

bigbryan
  • 411
  • 6
  • 19
  • 36
  • 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. – Rory Feb 26 '20 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? – GregGalloway Feb 27 '20 at 00:30

0 Answers0