sum by rows in Pivot

[Dinesh]

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

 

[Roger Govier]

Hi Dinesh

your data is in the wrong format for this to work.
The PT will not carry out a Grand Total by row, as A and B may not be
additive - column B could be Apples and column B could be Pears.

For the Grand Total to come into effect, the data should be

A B C
Row TYpe Value
a A 7
a B 16
b A 3
b B 5

etc.

Then with Row as the Row Field, Type as the Column Field and Value as the
Data field
you would see

Sum of Value Column LabelsRow
B C Grand Total
a 7 16 23
b 3 5 8
d 13 4 17
f 7 5 12
m 9 8 17
n 6 6 12
r 2 9 11
s 4 9 13
v 4 2 6
x 8 4 12
Total 63 68 131

Because A and B are Items of Type, the PT will add the values together.

--

Regards
Roger Govier

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

__________ Information from ESET Smart Security, version of virus
signature database 5175 (20100605) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5175 (20100605) __________

The message was checked by ESET Smart Security.

http://www.eset.com