Pivot Tables-2 questions

[CrimsonPlague29]

Question # 1

I have a pivot table that's laid out similar to below.
| Build Cell 1 | Build Cell 2
----------|--------------------------------------|--------------------------------------
Part # | Prod A Prod B Prod C Prod D | Prod A Prod B Prod C Prod D
123 | 3 1 | 3 1
456 | 4 1 | 2
789 | 5 | 4
----------------------------------------------------------------------------------------
I would like it to look like the chart below. Only showing the products
that are being produced in that specific Cell automatically when the pivot is
created.

| Build Cell 1 | Build Cell 2
--------|---------------------------|---------------------------
Part # | Prod A Prod B | Prod C Prod D
123 | 3 1 | 3 1
456 | 4 1 | 2
789 | 5 | 4

Question #2
How can you set the pivot table to automatically add a data column once it's
entered into the main data area without having to go into layout and manually
adding???
eg. add part # for product E and have it appear in the Cell 2 section

Thanks in advance for any help...

 

[Debra Dalgleish]

Unless you have the product field set to "Show items with no data",
products with no data for any part shouldn't appear in the pivot table.

Your source data should have a single field that stores the product
name, rather than a separate field for each product. Then, when you
refresh the pivot table, any new products would appear automatically.

To ensure that new rows or columns are included in the pivot source
data, you can base the pivot table on a dynamic range. There are
instructions here:

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

 

[CrimsonPlague29]

Thanks....didn't have the single field had dual, changed it an works great.

CrimsonPlague29