Hi, I have a spreadsheet containing sales data for the year for a number of sales reps. I'd like to filter the data by rep and quarter and show selected columns, e.g. revenue, date of sale, etc. but exclude other columns, e.g. invoice date etc. Do i do this using a pivot table or by sorting? When I try to create a pivot table it wants to perform an action on the column data (e.g. sum or average it) and I want it shown as it is in the original. Thanks for your help