Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Pivot Table, Count and Sum

Status
Not open for further replies.
phkhong

phkhong

Technical User
Jan 15, 2002
8
AU
Hi,

I have the following fields which I would like to include in a PivotTable
- PartNumber
- Location
- Cost

Required PivotTable

Count Location GrandTotal
PartNumber Cost LocA LocB LocC Count Sum
PartNumber1 100 5 3 8 800
PartNumber2 200 4 6 10 2000
PartNumber3 300 1 2 3 900

Designing the PivotTable with GrandTotal(Count) is easy but does anyway know if it is possible to add to the PivotTable the GrandTotal(Sum)=GrandTotal(Count) x Cost
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
530
mintjulep
M
arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
186
arvarr
arvarr
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
733
remeng
remeng
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
912
remeng
remeng
feipezi
  • Locked
  • Question
How to detect dups and/or sum by group?
Replies
1
Views
200
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top