If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PivotTables in Excel 2004 calculate incorrect standard deviations | lvphj | Worksheet Functions | 0 | May 12th, 2005 05:30 PM |
Drill Down in PivotTables | astrodon | General Discussion | 0 | February 4th, 2005 04:51 PM |