CODEWITHSUNDEEP
excelpivot
rhughes
rhughes

Reputation: 9583

Excel 2012 Pivot Table Displayed Data

I am trying to make a simple bug viewer with Excel. I think I need a pivot table for this.

I have attached a screen shot of what I have got so far. What I would like, is instead of the 'Count of x' columns, is the actual data to be displayed.

Excel 2012 Pivot Table Bug Viewer

My data table is formatted as follows:

Excel 2012 Sample Data

Thank you very much,

Richard Hughes

Upvotes: 0

Views: 7605

Answers (1)

Julian Knight
Julian Knight

Reputation: 4923

You cannot have the actual text displayed in those columns. The columns show aggregated data. You can have counts and sums, averages, etc.

I think that what you want is the "classic" pivot table view. Go into the pivot table options, Display tab and select "Classic Pivottable Layout".

Then add the data you want to see as "Row Labels" not Values. You might want to keep a count of ID as a value. Is that better?

Upvotes: 2

Related Questions