Aug 07 2020 09:48 PM - edited Aug 07 2020 09:52 PM
As we know we can expand/collapse Row Headers or Column Headers in Pivot Tables to reveal details. When we expand column headers, it expands rightwards. My objective is to make it expand downwards (vertically).
You can see in the attached images that clicking the plus sign expands a column label but rightwards, not downwards.
I would really appreciate if someone can help me with this.
Thank you so much.
Aug 07 2020 11:25 PM
@sohailzamani I dare to say that this is just how collapsing/expanding works in pivot tables. Perhaps a silly suggestion, but why not use the column headers as row headers in stead? The attached workbook demonstrates what I mean, although I don't know if this is similar to your actual pivot table.
Aug 09 2020 08:11 AM