View Single Post
 
Old 04-23-2020, 03:08 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by gebobs View Post
I suppose I could add another field in it after the last column that would put everyone into buckets and pivot on that.
Yes, if you want to have both annual and generation grouping in the same pivot then that's a very easy way to do it. See attached.
Attached Files
File Type: xlsx msoofficeforums44797Sample.xlsx (47.2 KB, 6 views)
Reply With Quote