Prev: maintaining constant percentage
Next: what tab for calculating percent and decimal?
From: Dinesh on 5 Jun 2010 12:44
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
From: Roger Govier on 5 Jun 2010 13:12
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" <Dinesh(a)discussions.microsoft.com> wrote in message
news:BE79F871-95FF-4EBA-BBB5-061954DB2837(a)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



 | 
Pages: 1
Prev: maintaining constant percentage
Next: what tab for calculating percent and decimal?