I have a pivot table displaying 2016 and 2017 data. I would like to filter out the Top 10 using only the 2017 column data. Currently it seems to take the Top 10 of both columns and give me that. I want 2016 simply to appear as a historical reference for my 2017 data. I have attached an example. Thank you for your time.
How do I change Top 10 to filter only 1 year
- Thread starter sueMN
- Start date
Pecoflyer
Admin Alumnus
- Joined
- Oct 13, 2011
- Messages
- 1,802
- Reaction score
- 1
- Points
- 38
- Location
- Brussels Belgium
- Excel Version(s)
- 2010 on Xubuntu - O365
Hi and welcome
why not post the excel sheet so we can work on it?
why not post the excel sheet so we can work on it?