Pivot Tables-2 questions

  • Thread starter CrimsonPlague29
  • Start date
C

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...
 
D

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
 
C

CrimsonPlague29

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

CrimsonPlague29
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top