Is there any way to change the pivote view for columns in below format?
Header 1 (Parent Hierarchy)
Header 2 (Child Hierarchy)
Line item 1 (Line items in Module)
Line item 2 (Line items in Module)
Header 2 Total (Child Summary)
Can you attach a screenshot of your scenario or it's a self-created question by you?
No you cannot mix the List and Line Items in between. The maximum you can keep the List and Line Items in Rows to view them side by side.
NO, its not possible. But if you want to export the data in such a way, then do use export options.