PivotTable Field Values - How to show raw data only?

S

sml

New Member
Joined
May 21, 2007
Messages
4
I am setting up a PivotTable and only want to show the actual raw data values in the PivotTable field and NOT any sum, count, average, max, min, etc etc.

How can I do this? I only seem to have the options for sums, counts, etc. There are no options for just presenting the data.

So for example, rather than a PivotTable that results in counts of 1, 1, 1 in each cell, I want it to show Compay1, Company2, Company3, etc.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
sml,
Pivot Tables are designed to count

What you can do is as follows;
Lets say you wanted to list the companies by location

You can drag "Location" + "Company" to the row field and then drag either to the data field and assign the count option

This will produce a list of Locations in the first column, Companies at the location in the second column and a count of the combination


dsm
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question
VBA Dynamic PivotTable Name
Replies
4
Views
481
th259
T
ajjava
  • Question
Procedure to find MAX VALUE in a SPECIFIC pivot table value field, in the case of MULTIPLE pivot table value fields
Replies
0
Views
816
ajjava
ajjava
T
  • Question
VBA Calculated Field - Subtract Value in Data Field from Value in Row Field
Replies
0
Views
211
th259
T
F
  • Question
PivotTable Percentages - Total Column Correct; Weekly Columns Not
Replies
3
Views
268
futureprimitive
F
S
  • Question
Too many characters in the cells of my Pivot Table?
Replies
0
Views
420
SorenN
S

Forum statistics

Threads
1,214,653
Messages
6,120,755
Members
448,989
Latest member
mariah3

Share this page

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
Back
Top