Pivot Table - without aggregating/Summarizing

[JK]

Hi ,
I have data that looks like

NAME DATE VALUE
a Jan 10
a feb 12
b jan 13
b Feb 14
c Jan 15
c Feb 16

 

[Peo Sjoblom]

Drag the NAME field to the row and the DATE field to the column, right
click report and select table options, then deselect both Grand totals
options

 

[JK]

Hi ,
I did as you said, I dragged the value field in to the Data Area , it
automatically does a count - I tried Sum, but it just says 1 ..

 

[Debra Dalgleish]

Your values may be text, instead of numbers. There are instructions here
for changing them to real numbers:

http://www.contextures.com/xlDataEntry03.html

Then, refresh the pivot table, and the sum should work correctly.

 

[JK]

Thanks - it works !!

Your values may be text, instead of numbers. There are instructions here
for changing them to real numbers:

http://www.contextures.com/xlDataEntry03.html

Then, refresh the pivot table, and the sum should work correctly.