PDA

View Full Version : Pivot > Showall data in rows field



ChrisAcheson
12-21-2016, 04:33 AM
Hi All

In rows field, I have 'Reason'

is any one able to help 'show all data' which splits out my reason codes, and each tab represents code 1, 2,3,4 etc?

Thank you.


With ActiveSheet.PivotTables("PivotTable1").PivotFields("ReasonCode")
.Orientation = xlRowField
.Position = 1
End With

Bob Phillips
12-22-2016, 07:17 AM
Bit scarce on details!

Did you try doing it with the macro recorder on?