hi all,

I have an excel sheet with several columns, some of which are:

* Purchase Date (in YY-MM-DD HH-MM-SS) format.
* Customer Name
* Product Name
* Transaction Value (sales per transaction).

This excel file is exported from an old legacy system.

I need to create a report in which a user selects a YEAR and a MONTH and see:

1) A list of customers, the products that amount for 80 percent of the customer's sales, and the sales amount.

2) A list of 5 customers that account for the most overall sales, and the 5 products they bought the most.

I'm new to this kind of thing in Excel. Any suggestions as to how I go about it?

Thanks in advance,

L.

Howdy and welcome to the board. What version of Excel are you using? If not 2007, then it sounds like you are trying to put too many items into columns, exceeding the 256 column limit. Try to move the customers to the rows of the pivot table rather than in columns.