O OAhmed New Member May 26, 2017 #1 Hi, Help!!! I need a pivot table with Row/Value and than Row/Value again. I am not sure if I have explained this properly, please see a sample attached. Thanks in advance Owais Ahmed Attachments Pivot.xlsx 14.3 KB · Views: 8
Hi, Help!!! I need a pivot table with Row/Value and than Row/Value again. I am not sure if I have explained this properly, please see a sample attached. Thanks in advance Owais Ahmed
Chihiro Excel Ninja May 26, 2017 #2 Not possible. Pivot requires all row label field to be left of data field. Workaround is to use two pivot tables (hide INV NO in second pivot).
Not possible. Pivot requires all row label field to be left of data field. Workaround is to use two pivot tables (hide INV NO in second pivot).
