L
Landmark
Dear all, I hope someone can help me. I have a worksheet of data
showing description down the left side, months across the top, and
amounts in the data fields, it look ssomething like the little table
below. Note how I have several columns for each month, as the forecast
is broken down into weeks.
Aug-05 Aug-05 Sep-05
Wk 3 Wk 4 Wk 5
Product 1 10
Product 2 20
Product 3 5 30
Total 15 20 30
I want to create a pivot table and a pivot graph to show the total
sales for August, the total for September 05 etc. But when I create my
pivot using the product descriptions to form the rows, and the month
headings to form the data, I end up with a table that shows me colomns
of data entitled Aug 05, Aug 052, Sep 05, Sep 052, Sep 053, Sep 054 etc
etc.
How can I get round this, can I somehow easily tell the pivot table to
group all the Aug 05 into one column and give me one total?
Kind regards
showing description down the left side, months across the top, and
amounts in the data fields, it look ssomething like the little table
below. Note how I have several columns for each month, as the forecast
is broken down into weeks.
Aug-05 Aug-05 Sep-05
Wk 3 Wk 4 Wk 5
Product 1 10
Product 2 20
Product 3 5 30
Total 15 20 30
I want to create a pivot table and a pivot graph to show the total
sales for August, the total for September 05 etc. But when I create my
pivot using the product descriptions to form the rows, and the month
headings to form the data, I end up with a table that shows me colomns
of data entitled Aug 05, Aug 052, Sep 05, Sep 052, Sep 053, Sep 054 etc
etc.
How can I get round this, can I somehow easily tell the pivot table to
group all the Aug 05 into one column and give me one total?
Kind regards