pivot Table Newbie

T

tech lead

I have '03, '04 & '05 sales data, with the following column headings:

"Customer Inv Date Item # Qty Price Total"

I have sorted the source data first by Customer and then by Inv Date.
The Inv Date is in the following format; mm/dd/yyyy.

I need total sales by customer by year. I can do a basic Pivot Table
and sort it so that it gives me a listing by customer in descending
order of total (aggregate of 3 years) sales.

My problem is that I can't figure out how to subtotal sales by year.

Hope this isn't too confusing - any help would be appreciated!!!
 
R

Rowan Drummond

In the Pivot Table right click int he Invoice Date field. Select "Group
and Show Detail" then select "Group". In the By box click on Years (make
sure nothing else is highlighted). Click Ok. You should now have your
totals by years.

Hope this helps
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sort data in data area in a pivot table 1
Pivot Table Data Column Sort Excel 2007 1
Rank in Pivot Table 3
Group by month in a Pivot table 2
Pivot Table "Difference From" Question 4
How to sort data in data area in a pivot table 2
Count(s) in Pivot Table 4
summing total sales formula 1

Top