Display Data Values (Not Aggregates) in Pivot Table

[krysolov]

Here's a simplified scenario:
Column 1 contains production line code
Column 2 contains production date
Column 3 contains shift number
Column 4 contains item number that will be produced

I create a pivot table with line/shift as rows and date as columns and would like to display the actual item number in the values section. Is there a way? Currently it tries to display an aggregate function (sum, count, etc.) of the value, but not the value itself.

Thank you

 

[SkipVought]

Hi,

Well that's what a pivot does -- AGGREGATES!!!

Try this: Double-Click any aggregation value in your PT.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[krysolov]

I know, damn those functions that work as designed!

Here's the task: I would like to have a report that will show users which items will be produced on which line, by date. Pivot tables make it easy for me to set up the columns and rows by which the report should be presented and if I needed to show the total quantity produced, it would have been perfect. However, all I need is to show the actual item number.

Requiring users to double-click on the value to display which item it relates to in a separate tab would not work, because the idea is to give users a way to determine at a quick glance when and where something is going to be produced (our firm schedule is only 7 days out with about a dozen production lines, so the report in its intended form would have been perfect).

Since PT's do aggregate values, is there any other function within Excel that might help me produce that output? VBA?

 

[SkipVought]

use MS Query.

faq68-5829

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

or use a PT, but drag the numeric value(s) into a ROW field and aggregate occurrences (count of...) which is probably meaningless and could be hidden I suppose.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}