Re: Pivot table sum issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The following article shows the limits in Excel 2003 pivot tables.

http://support.microsoft.com/kb/820742/

Perhaps you can move the Item field to the Page area of the pivot table. Then try to add the second data field, and drag the Data button to the Total cell, as I described earlier.

If that works, you may be able to move the Item field back to the Row area.

Phil Smith wrote:
As soon as I throw in the second field, I get an error concerning too many fields. Yes, they are seperate coloums in my data table.


Debra Dalgleish wrote:

No, those instructions are for 2003.
What happens when you try to put both Cost and Sale in the Data area?
Are they separate fields in the source data?

Phil Smith wrote:

Thanx Debra, but no dice. Could this be a 2007 feature? I am working with 2003...

Debra Dalgleish wrote:

You can put both Cost and Sale in the Data area.
Then, drag the Data field button onto the cell that says "Total".
There's a picture here:

http://www.contextures.com/xlPivot02.html

Phil Smith wrote:

My data looks so,ethign like this:


Item Country Cost Sale
Table USA 5 10
Canada 7 12
Foreign 22 56
Chair USA 3 10
Canada 4 9
Foreign 9 21

Etc.

I want to subtotal Cost and Sale for each change in Item, ONLY at each change in item.

Item Country Cost Sale
Table USA 5 10
Canada 7 12
Foreign 22 56
Total 34 78
Chair USA 3 10
Canada 4 9
Foreign 9 21
Total 16 40

I can't put both in the data area, and it makes no sense to put them in the coloum fields, as far as I can tell. However, when I put subtotals on cost and sale, it also breaks on cost and sale. I wnat to subtotal cost and sale, but break ONLY on Item. How?

Thanx










--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

.

Relevant Pages

  • Re: Pivot table sum issue
    ... What happens when you try to put both Cost and Sale in the Data area? ... Foreign 9 21 ... I can't put both in the data area, and it makes no sense to put them in the coloum fields, as far as I can tell. ...
    (microsoft.public.excel.misc)
  • Re: Pivot table sum issue
    ... You can put both Cost and Sale in the Data area. ... Foreign 9 21 ... I can't put both in the data area, and it makes no sense to put them in the coloum fields, as far as I can tell. ...
    (microsoft.public.excel.misc)
  • Re: Pivot table sum issue
    ... Canada 4 9 ... Foreign 9 21 ... I want to subtotal Cost and Sale for each change in Item, ONLY at each change in item. ...
    (microsoft.public.excel.misc)
  • Re: Pivot table sum issue
    ... What happens when you try to put both Cost and Sale in the Data area? ... Canada 4 9 ... Foreign 9 21 ...
    (microsoft.public.excel.misc)
  • Re: Dear Ford: Time to end the price "ass-rape" of Canadians
    ... Canada SHOULD NOT cost $39,000 for a GT and $28-$29K in the U.S. Get ... or get the f--- out of business. ... manufacturers sold in Canada both foreign and domestic, ...
    (rec.autos.makers.ford.mustang)