Hello Friends,
Please see the attached spreadsheet.
I have a pivot table showing Top 4 customers based on the Sales figures. To get the Top 4 items from the source data is straight forward. But I need to get the Top 4 customers ignoring certain customers from the Source data. That is without deleting the certain customers i dont want to appear on the Top 4, from the source file.
Is this achievable ? Also how do I remove the blank column ?
Thanks
Bookmarks