Hi

in a Pivot Table, can I show Total invoices for suppliers by region fairly
easily:

Region
Supplier Data Central East West Grand Total
ABC Sum of Invoices 766,469 703,255 631,646 2,101,370
Count of Invoices 74 70 59 203
DEF Sum of Invoices 776,996 1,532,159 494,919 2,804,074
Count of Invoices 60 76 42 178
XYZ Sum of Invoices 832,414 897,949 712,365 2,442,728
Count of Invoices 67 63 52 182
Total Sum of Invoices 2,375,879 3,133,363 1,838,930 7,348,172
Total Count of Invoices 201 209 153 563



question - can I show Count BESIDE Sum:

Region
Supplier Central East West Grand Total
Sum of Invoices Count of Invoices Sum of Invoices Count of Invoices Sum
of Invoices Count of Invoices Sum of Invoices Count of Invoices
ABC 766,469 74 703,255 70 631,646 59 2,101,370 203



Thanks

Eoin Bairéad
Dublin, Ireland

To arrange the fields horizontally, drag the Data field button onto the
cell that contains the word 'Total'.

There are instructions with pictures he

http://www.contextures.com/xlPivot02.html


Eoin Bairead wrote:
Hi

in a Pivot Table, can I show Total invoices for suppliers by region fairly
easily:

Region
Supplier Data Central East West Grand Total
ABC Sum of Invoices 766,469 703,255 631,646 2,101,370
Count of Invoices 74 70 59 203
DEF Sum of Invoices 776,996 1,532,159 494,919 2,804,074
Count of Invoices 60 76 42 178
XYZ Sum of Invoices 832,414 897,949 712,365 2,442,728
Count of Invoices 67 63 52 182
Total Sum of Invoices 2,375,879 3,133,363 1,838,930 7,348,172
Total Count of Invoices 201 209 153 563



question - can I show Count BESIDE Sum:

Region
Supplier Central East West Grand Total
Sum of Invoices Count of Invoices Sum of Invoices Count of Invoices Sum
of Invoices Count of Invoices Sum of Invoices Count of Invoices
ABC 766,469 74 703,255 70 631,646 59 2,101,370 203



Thanks

Eoin Bairéad
Dublin, Ireland




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html