Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008

    Unanswered: Aggregated pivot out of an excel range

    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,


  2. #2
    Join Date
    Oct 2003
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts