View Single Post
 
Old 10-26-2014, 11:14 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I've rarely used pivot tables, so hopefully someone else can give more specific advice. I doubt, though, that even a VBA solution could avoid the need for a 'helper' column for the suffixes once it comes to actually generating the pivot table. Of course, if you add the equivalent formula to the data source you're generating the pivot from (yes, all 58,000 rows of it), or use a macro to generate the same output there, you could then generate the pivot table using the suffixes column instead of the labels column.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote