Hello,
I need help with PivotTable please. I have a sheet that has multiple columns with same names. i.e.:
Usages - Month 1 - Invoice - Month 1 - Discounts - Month 1
When I run the Pivot Table Report, under "Choose Fields to Add to the Report' it combines the columns with the headings 'Month 1'; is there any way to show me these fields as it appears on the data sheet and in the same sequence?
I would not be able to change the headings coz' sometimes I get over 50 sheets at a time.
All the help will be greatly appreciated.
Regards!
Shaheed Faiz
Bookmarks