Pivot Table Disable grouping

PD


Not that I know about. That is one of the functions of the Pivot Table - to do the grouping.

However, if you want to use code to do it all, then have it build the pivot table, then copy the results somewhere else, then use code to fill in the missing items. Then use that output to move forward.

rylo

Hi

Here's a pretty basic loop that should do the fill for you.

Please Login or Register  to view this content.

rylo

Hi

Bit of a closer look. Seems that columns D and E should always take the value from the last non blank entry, but column A-C should take the values from whatever row matches a non blank item in column A. So with that try

If that isn't always the case, then try to work out what the fill rules are and, if you can't modify the code, then advise what the rules are and I'll adapt.

Please Login or Register  to view this content.

rylo

In the Row field of the PivotTable,
reverse the order of the first three items to
Centre, Team Leader, A..Name.
Then change one line of the code to
If Not IsEmpty(Cells(r, c)) Or r = 3 Then