This question has been asked but I am not able to figure out what the meaning of the replies are and that’s why I thought, I will ask this question again with some pictures.
I needed to get a Grand Total of the Rows when I select the different fields, in the same fashion that I see the Grand Total of the Columns.
For example,
Var 1 and 2.JPG
Pic 1: When I select Variable 1 and Variable 2 in the fields, I should be able to see 174 (122+52)
And
Var 1 and Var 2 and Var 3.JPG
Pic 2: And when I select Variable 1, Variable 2 and Variable 3 in the fields, I should be able to see 518 (122+52+344).
Is this something feasible?
I read from others that if I drag and drop a field to the column labels section, then I can see Grand Total for the rows. This is true, but this is valid for only one field.
Thanks a lot in advance for reading this. I am using Microsoft Office 2010.
Bookmarks