Columns in a PivotTable

[bowens7945]

Question about getting data to show in columns in Pivot Tables.

I'm looking at customer data that I have joined from multiple locations; however, some of these locations serve the same customer but record the revenue at the respective location. I want to look at the data as a whole without regard to which location the customer revenue was recorded.

I have three years worth of data (2005, 2006, and YTD2007). I want to see the customer data on the left (column A) and each year's totaly revenue by customer in the columns to the right (columns B, C, and D, respectively).

Currently, when I add the 2005, 2006 and 2007 revenue fields to the data section, Excel places 2005, 2006 and 2007 customer revenue all in column B with a row for each customer underneath the customer name.

Any help would be greatly appreciated.

 

[Dan Waterloo]

It sounds like you have three different data fields - revenue for 2005, revenue for 2006, and revenue for 2007. Please correct me if I'm wrong. They line up under the Data button in column B. To get the effect you want, drag the Data button into the cell immediately to the right in the C column. It's probably titled "Total".

You could gain greater flexibility from your data if you had one data field called Revenue (rather than three different data fields) and one more category field called Year or Date that you would use to slice the revenue with. But that's another question.

 

[bowens7945]

Thansk for the reply. That's what I needed. I got it to work.