sum by rows in Pivot

  • Thread starter Thread starter Dinesh
  • Start date Start date
D

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
 
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

Dinesh said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top