0% found this document useful (0 votes)
9 views3 pages

Sales Data by Last Name and Country

The document presents sales data categorized by last names and countries, with a total sales amount of 152,915.00. It includes a pivot table detailing individual sales figures for various individuals across different quarters and countries. Notable entries include sales from Smith, Johnson, Williams, Jones, and Brown.

Uploaded by

SAVITA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views3 pages

Sales Data by Last Name and Country

The document presents sales data categorized by last names and countries, with a total sales amount of 152,915.00. It includes a pivot table detailing individual sales figures for various individuals across different quarters and countries. Notable entries include sales from Smith, Johnson, Williams, Jones, and Brown.

Uploaded by

SAVITA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Row Labels

BROWN
JOHNSON
JONES
LAST NAME
SMITH
WILLIAMS
(blank)
Grand Total
LAST NAME - all -

COUNTRY Sum of SALES


UK 65,390.00
UKL 9,339.00
USA 76,796.00
USA 1,390.00
(empty)
Total Result 152,915.00
PIVOT TABLE
LAST NAME SALES COUNTRY QUARTER
SMITH ### UK QTR 3
JOHNSON 14,808.00 USA QTR 4
WILLIAMS 10,644.00 UK QTR 2
JONES 1,390.00 USA QTR 1
BROWN 4,865.00 USA QTR 2
WILLIAMS 12,438.00 UK QTR 3
JOHNSON 9,339.00 UKL QTR 4
SMITH 18,919.00 USA QTR 3
JONES 9,213.00 USA QTR 2
JONES 7,433.00 UK QTR 1
BROWN 3,255.00 UK QTR 3
WILLIAMS 14,867.00 UK QTR 4
WILLIAMS 19,302.00 USA QTR 2
SMITH 9,689.00 USA QTR 1

You might also like