Pivot Table Question

mikeyredk

New Member
Joined
Jun 30, 2008
Messages
12
Long time lurker first time poster; with all this great knowledge in the forum I had no need to create an account because I pretty much found my answers using the search button (doesn't that make u warm and fuzzy inside :biggrin:)

The question… is it possible in a pivot table to have the column heads do OR not an AND.

The Setup… I have four columns one is Product A Usage, Product B Usage, Product C Usage, Product D Usage. The rows are by Part Number and description. The data set within is pricing data from three different years. Supplier is the page header. Some Part Numbers are used in multiple products.

The Rub… If I put all four Products on at the same time they will all go on there but there are a lot of blanks because that part is not being used to make that product. I select no blanks and I get only one set of Product Usage data associated with Part Numbers.

The wants… To be able to see all products at once, be able to manipulate it in a way that will allow me to dig though the data to understand the price increase and where is it coming from.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
hi - welcome to the board.

usual approach to excluding specific sub-sets of the source data from a pivot is to:

1) create extra column(s) in the source data - one for each exclusion condition you're applying
2) set up formula(s) to check for the condition(s)
3) if checking multiple exclusion conditions, set up final column as a global 'include / exclude' formula
4) put this last column in te pivot as a page field & set so as to only include the atomic records you're after.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,963
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top