Two columns of data in pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My raw data includes Name, SSN, Data, Amount1, Amount2. I want the left two
columns to be Name, SSN then Data columns of Amount1, Amount2. If I drag SSN
over, the pivot table creates a sub-total. If I hide the subtotal, the SSNs
disappear. If I drag into the data section, it won't display the SSN.
 
Put Name and SSN in the Row area, and the amount fields in the Data area.
Double-click on the Name field button
In the PivotTable Field dialog box, under Subtotals, select None
Click OK
 
Perfect. Thank you.

Debra Dalgleish said:
Put Name and SSN in the Row area, and the amount fields in the Data area.
Double-click on the Name field button
In the PivotTable Field dialog box, under Subtotals, select None
Click OK
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif over multiple columns 1
Deleting Cells with Duplicates 3
Finding count of unique number within a specific criteria? 7
Change columns into individual records 1
Calculated Textbox not showing proper results. 4
Average of Subtotals in Pivot Table 0
Using a field reference in a query critereon 0
merging data between two tables 6

Back
Top