PivotTable Value

[Glasgowsmile]

I have a large set of data, with a lot of duplicate information that is associated with unique information. I need a way that a user can easily sort the data to find what they're looking for and it seems like Pivot Table is the way to go. The biggest problem I have is the values as it does SUM for all the numbers but I just want it to display the numbers as it is listed in the dataset, not adding it up or anything like that.

How do I do that?

Also, is there a better way to create this sheet?

Below is a small example of the sheet I'm referring too. The actual dataset is about 20k lines or so.

https://imgur.com/2sNjZUo

 

[fhqwgads]

whats your pivot table look like right now?

 

[mrshl9898]

Can't you put the values field in the column section?

 

[fhqwgads]

probably better in the rows section than column. or even in both rows and values and change values to count instead of sum so you know which have duplicates if that's what your looking for

 

[mrshl9898]

oops, meant rows.

 

[Glasgowsmile]

Here is an example. The Pivot Table at this time is doing the average of the numbers but I really just need it to pull the raw number as it is listed in the data.


https://imgur.com/AbOfA6I

 

[fhqwgads]

from the Pivot Table Field List, drag Rate to the bottom of your Row Labels under Room Type. your Rate should be in both Row Labels and Values. keep the value as an average of Rate