HI,
I'm working with a database that has the following data: customer, product, month, selling price, quantity sold.
I've created a pivot table where I have the customer and package on the page, selling price in the row, month in the column and quantity sold in the data. For the quantity sold I have the option set to % of column.
This table gives me the % of quantity sold by price for each month by customer and package. Of course, the % of column for each month totals 100%.
My issue is that if I move the product off the page and to the left of selling price, the % of column totals 100% at the grand total. I need the % to come to 100% for each product.
I've tried relaying out my data in different columns & rows and use % of row. This layout gives my the results I need, however, it is very difficult to read as each product is sold at a large range of price points.
Please help! A solution will be greatly appreiciated.
Lori
I'm working with a database that has the following data: customer, product, month, selling price, quantity sold.
I've created a pivot table where I have the customer and package on the page, selling price in the row, month in the column and quantity sold in the data. For the quantity sold I have the option set to % of column.
This table gives me the % of quantity sold by price for each month by customer and package. Of course, the % of column for each month totals 100%.
My issue is that if I move the product off the page and to the left of selling price, the % of column totals 100% at the grand total. I need the % to come to 100% for each product.
I've tried relaying out my data in different columns & rows and use % of row. This layout gives my the results I need, however, it is very difficult to read as each product is sold at a large range of price points.
Please help! A solution will be greatly appreiciated.
Lori