Pivot Table Does Not Show Separate Lines for 2 Rows of Data That Match

[DMumme]

I am using Excel 2013. I have a large data field from which I have created a Pivot Table. One of my fields is "Amount". When two rows in the data field exactly match one another, the Pivot Table Rows area only shows one of the rows, but the Values area Sums the two rows for Amount. I would like both rows to be reflected in the Pivot Table. Is this possible?

If the Pivot Table would show each row from the Data Source, the Value column would not be needed.

 

[DMumme]

I am using Excel 2013. I have a large data field from which I have created a Pivot Table. One of my fields is "Amount". When two rows in the data field exactly match one another, the Pivot Table Rows area only shows one of the rows, but the Values area Sums the two rows for Amount. I would like both rows to be reflected in the Pivot Table. Is this possible?

If the Pivot Table would show each row from the Data Source, the Value column would not be needed.

Actually, the Value column appears to be required in order to get subtotals and grand totals. However, if I could get the Pivot Table to show both rows I would not want the Value Row to "double up" by summing the two rows on each row if that is what would happen.

 

[DMumme]

I found a workaround. I added a column to the Data Source called Row. Each cell in the column is equal to the row number for that data item. Now the Data for one row is not exactly the same as another row. I put the "Row" field in the ROWS area on the Pivot Table and then hide the column. I eliminated the Amount from the ROWS area in the Pivot Table ad kept the Amount in the Values area. Works perfectly.