Pivot subtotals summing columns displayed at the bottom

[#1]

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

[#2 · Accepted solution]

hi

01. select Vendor name (Field) on the presentation tab

02. Check on Shaw partial Sum

03. on subtotal select buttom

04. u will get the result

tito

[#3]

Thanks mate,

It worked, it was just that the real data was bigger than the sample, so the totals were pushed down, very embarassing