------ Register to get rid of these "In Post" ads! ------


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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/worksheet-functions/207377-sum-rows-pivot.html#post738840
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

------ Register to get rid of these "In Post" ads! ------


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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/worksheet-functions/207377-sum-rows-pivot.html#post738853
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" <Dinesh@discussions.microsoft.com> wrote in message
news:BE79F871-95FF-4EBA-BBB5-061954DB2837@microsoft.com...
> 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