If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sum by rows in Pivot
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 |
#2
|
|||
|
|||
sum by rows in Pivot
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|