Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Pivot Tables (Data Analysis) in excel 2000
From:	Tony Beckett <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 20 Dec 2000 07:13:00 -0000
Content-Type:	text/plain
Parts/Attachments:	text/plain (16 lines)

Keith,

I don't think you need a pivot table for this.
Try sorting the whole range of data using your suppliers as the key
column.
Once sorted use Data/Subtotals. Choose "at each change in
supplier" and then get a total done on the appropriate column.

Regards
Tony
(Tony Beckett, Rutland, UK)

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                    http://nospin.com/pc/pcsoft.html

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG