Search results for query: *

i got it! I created new columns and used a formula like =a2&"1" to create new unique names for the second & third row fields. The problem was like this... GPPG: Industrial CGPPG: Industrial CIPPG: raw Getpivotdata couldn't figure out what industrial i wanted, so now it would be: GPPG...

I've never used DGET before....here's the thing though, Every month I will be pulling more information from the pivot table, based upon the same criteria with only the month changing. Now, the report i am working on will have the data for Jan, Feb, Mar, etc... as the year moves on, so i have to...

Hello. I think i have hit a brain block...i'm hoping you can help me. I am using Excel 2000 and need to get some things accomplished with GETPIVOTDATA. Here's the set up... Data value: AvgUnitCost Column Headers: Month... jan, feb, etc... Row Fields: GPPG (examples: Industrial, HWT, HWF)...

Thanks you guys! I appreciate all of this information! I'll take all of this and develop from there. :-) I really really appreciate it!

I agree with you on the downfall & production being in one table. As I look at it, i realize that this would best service the database. Thank you so much for your input!

Tbl_Base could be compared to a table similar to Tbl_Invoice. My vision on this is as follows... The Tbl_Line holds the information regarding the names of the process lines. Wood is run through one of several process lines to come to a finished product. I have to report on the...

Hello all! I have developed several databases but really seem to be drawing a blank here. My brain has frozen. I am trying to normalize a database i took over... Ok...after reading everything here and trying to apply it appropraitely, i have come up with the tables i show in the attachment, but...