Hi,

see table below.


Col A Col B Col C
a 1 7
s 4 9
x 8 4
d 9 3
v 4 2
b 3 5
n 6 6
m 9 8
r 2 9
d 4 1
a 6 9
f 7 5

See Excel 2007 Pivot table result below.


Values
Row Labels Sum of Com B Sum of Col C
a 1 7
s 4 9
x 8 4
d 9 3
v 4 2
b 3 5
n 6 6
m 9 8
r 2 9
d 4 1
a 6 9
f 7 5
Grand Total 63 68

I am not getting "Grand Total" by row in Excel 2007.

Can someone explain why?

Thanks,
Dinesh