Pivot Table Head Scratcher!!!

dyaron

Active Member
Joined
Nov 26, 2007
Messages
291
I need some help here guys! I've created a pivot table as the following:

Column A going down is Purchase Order
Row 1 going across is Classification

In essence, a PO has 3 difference classifictions that have a unique Activity number... I want it to look like this...

PO.......Class 1......Class 2......Class 3
#1.......12345.......23456.........34567
#2.......45678.......56789.........67890

and so on and so on... however, the "activity numbers defined under each class are being "summed". I guess what I'm trying to accomplish is not SUM the info in the "DATA" area... i simply want to SEE the DATA!! How do I make it to show the actual activity number, and not the sum of how many isntances have that po number? help is much appreciated!!! Thanks!
 
Last edited:

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,258
Are you saying that you can have several "activity numbers" for each PO / Class permutation ?

If yes, suggest adding "activity number" as a second column on the left hand side of the pivot table.
Then, change the field setting for the data to MAX.
 
Upvote 0

Forum statistics

Threads
1,191,231
Messages
5,985,418
Members
439,963
Latest member
Triarch

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