Ok so I have over 11 years (attached example just part of the data) of monthly returns and quintiles for companies. I've quintiled the companies out by month then I matched up the companies returns for those periods (starting in column AL). I'm trying to figure out a way to easily summarize this data. I want to see what the returns are of the companies over different time periods based on what quintile they are in. I thought maybe I could use multiple pivot tables based on the same data but am struggling to do that. Any help would be much appreciated!
Cheers![]()
Bookmarks