I have searched this forum and unfortunately, found numerous similar requests, but couldnt find what i was looking for, apologies if it has been already addressed

What i have is as follows

Vendor name in the row component of the pivot

Year in the column component of the pivot

and the Amount as the key measure

              Year

Vendor   amount

E.g.

         2007    2008  2009

A     10         11         12

B    15         17          13

C      11        10          14

I need the the totals displayed at the bottom of the column and not at the end of the row.

I have tried, partial sums, subtotals at bottom etc, and it all generates totals to at the end of the row

 I get this

         2007    2008  2009  Totals

A     10         11         12        33

B    15         17          13       45

C      11        10          14       35

I need the following

         2007    2008  2009

A     10         11         12

B    15         17          13

C      11        10          14

Totals     36           38         39

I am using the personal version of QV, so i can't upload the qvw file, any help woudl be appreciated, Thanjs