ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting in Pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/262952-sorting-pivot-table.html)

Jenifer

Sorting in Pivot table
 
I have a data set I am putting into a pivot table to show the data over time
but do no not want the data added up.
I have the product as a page by, the classification in row, mont in column,
and # and % in data. The problem is it is adding the West New Customers and
West Continuing Customers together. The data is already calculated so I just
need the pivot to view the months across columns and the ability to choose a
product to view. Is this possible without changing the data itself?
example:
Product CLASSIFICATION MONTH # %
Cable TV Current Customers 1/1/2010 400 100.00%
Cable TV New Customers 1/1/2010 100 25.00%
Cable TV * West 1/1/2010 20 5.00%
Cable TV * Southwest 1/1/2010 40 10.00%
Cable TV * South 1/1/2010 40 10.00%
Cable TV Canceled Customers 1/1/2010 0 0.00%
Cable TV Continuing Customer 1/1/2010 300 75.00%
Cable TV * West 1/1/2010 150 37.50%
Cable TV * Southwest 1/1/2010 75 18.75%
Cable TV * South 1/1/2010 75 18.75%
Cable TV Returning Customers 1/1/2010 0 0.00%
Cable TV Total Customers 1/1/2010 400 100.00%
Cable TV Current Customers 2/1/2010 400 100.00%
Cable TV New Customers 2/1/2010 100 25.00%
Cable TV * West 2/1/2010 20 5.00%
Cable TV * Southwest 2/1/2010 40 10.00%
Cable TV * South 2/1/2010 40 10.00%
Cable TV Canceled Customers 2/1/2010 0 0.00%
Cable TV Continuing Customer 2/1/2010 300 75.00%
Cable TV * West 2/1/2010 150 37.50%
Cable TV * Southwest 2/1/2010 75 18.75%
Cable TV * South 2/1/2010 75 18.75%
Cable TV Returning Customers 2/1/2010 0 0.00%
Cable TV Total Customers 2/1/2010 400 100.00%

Thank you!
Jenifer



All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com