Pivot Table

[diane072]

I have data where a social security number is in column A, and the person's name is in Column B. The remainder of the columns are dates and hours. I also have a column for quarter number (1,2,3.4). I created a pivot table that will total the hours by quarter, by person. The pivot table only will show either the SSN or the Name, as they are in different columns. I want to know if there is a way to have both columns display on the pivot table. Sometimes we use SSN and sometimes we use Name to compare this data to other data we obtain. So having both display as separate fields would help us.

 

[colbymack]

You should be able to add the Name and the SSN as Row items to be displayed. This will initially produce a total for each (which should be the same). You can then hide one of the total rows so as to reduce redundancy. I would put SSN first just in case 2 people happen to have the same name.

hth
colbymack

 

[diane072]

Thanks that worked. I can live with the subtotals in there. It would be great to not have them show up at all, but that works fine. I woudn't take the time to hide those rows - some are 1,000 rows long.

Thanks!
Diane

 

[GorD]

To remove the subtotals-

right click the pivot table, select wizard and then layout. Double click the first row field and then change the subtotal option from auto to none.

Hope that helps

 

[diane072]

Yes - that worked !!

Thank you

Diane