Home |
Search |
Today's Posts |
#1
|
|||
|
|||
New to Pivottables- need help
Greetings, I am trying to set up a pivot table but have run into several
issues. I work for a mining company and am trying to track tons mined by date and mine. Here is an example of how I have my source data setup- (a1)Date (b1) Mine (c1) Raw Tons (d1) Clean Tons (e1) Yield % I want to be able to sort all of these individually, such as sort Cleans tons or raw tons, and so on. Thank you in advance for any help you may have for me. |
#2
|
|||
|
|||
What issues have you run into?
coal_miner wrote: Greetings, I am trying to set up a pivot table but have run into several issues. I work for a mining company and am trying to track tons mined by date and mine. Here is an example of how I have my source data setup- (a1)Date (b1) Mine (c1) Raw Tons (d1) Clean Tons (e1) Yield % I want to be able to sort all of these individually, such as sort Cleans tons or raw tons, and so on. Thank you in advance for any help you may have for me. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTables in Excel 2004 calculate incorrect standard deviations | Excel Worksheet Functions | |||
Drill Down in PivotTables | Excel Discussion (Misc queries) | |||
Drill Down in PivotTables | Excel Discussion (Misc queries) |