Scribd
Upload
34 views

Filter Data Set

This document contains sales data for various individuals listed by their last name, the amount of their sales, the country, and the quarter. It shows sales figures for 15 people from the UK and USA across 4 quarters.

Uploaded by

SanjeevanR
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
34 views

Filter Data Set

This document contains sales data for various individuals listed by their last name, the amount of their sales, the country, and the quarter. It shows sales figures for 15 people from the UK and USA across 4 quarters.

Uploaded by

SanjeevanR
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
You are on page 1/ 5

Last Name Sales Country Quarter

Smith $16,753.00 UK Qtr 3


Johnson $14,808.00 USA Qtr 4
Williams $10,644.00 UK Qtr 2
Jones $1,390.00 USA Qtr 3
Brown $4,865.00 USA Qtr 4
Williams $12,438.00 UK Qtr 1
Johnson $9,339.00 UK Qtr 2
Smith $18,919.00 USA Qtr 3
Jones $9,213.00 USA Qtr 4
Jones $7,433.00 UK Qtr 1
Brown $3,255.00 USA Qtr 2
Williams $14,867.00 USA Qtr 3
Williams $19,302.00 UK Qtr 4
Smith $9,698.00 USA Qtr 1
Last Name Sales Country Quarter
Smith $16,753.00 UK Qtr 3
Johnson $14,808.00 USA Qtr 4
Williams $10,644.00 UK Qtr 2
Jones $1,390.00 USA Qtr 3
Brown $4,865.00 USA Qtr 4
Williams $12,438.00 UK Qtr 1
Johnson $9,339.00 UK Qtr 2
Smith $18,919.00 USA Qtr 3
Jones $9,213.00 USA Qtr 4
Jones $7,433.00 UK Qtr 1
Brown $3,255.00 USA Qtr 2
Williams $14,867.00 USA Qtr 3
Williams $19,302.00 UK Qtr 4
Smith $9,698.00 USA Qtr 1
Last Name Sales Country Date
Smith $16,753.00 UK 4/25/2010
Johnson $14,808.00 USA 1/5/2013
Williams $10,644.00 UK 4/13/2012
Jones $1,390.00 USA 9/5/2013
Brown $4,865.00 USA 1/21/2010
Williams $12,438.00 UK 4/6/2010
Johnson $9,339.00 UK 1/14/2013
Smith $18,919.00 USA 7/16/2011
Jones $9,213.00 USA 1/26/2012
Jones $7,433.00 UK 11/1/2010
Brown $3,255.00 USA 5/18/2012
Williams $14,867.00 USA 1/5/2012
Williams $19,302.00 UK 8/23/2013
Smith $9,698.00 USA 1/17/2013
Last Name Sales Country Quarter
USA Qtr 4 1 For AND Condition Use Country=U
UK Qtr 1 For OR Condition Use (Country=US
To display the sales in the USA in Q
Last Name Sales Country Quarter
Smith $16,753.00 UK Qtr 3
Johnson $14,808.00 USA Qtr 4
Williams $10,644.00 UK Qtr 2
Jones $1,390.00 USA Qtr 3
Brown $4,865.00 USA Qtr 4
Williams $12,438.00 UK Qtr 1
Johnson $9,339.00 UK Qtr 2
Smith $18,919.00 USA Qtr 3
Jones $9,213.00 USA Qtr 4
Jones $7,433.00 UK Qtr 1
Brown $3,255.00 USA Qtr 2
Williams $14,867.00 USA Qtr 3
Williams $19,302.00 UK Qtr 4
Smith $9,698.00 USA Qtr 1
ndition Use Country=USA and Quarter=Qtr 4
dition Use (Country=USA and Quarter=Qtr 4) OR (Country=UK and Quarter=Qtr 1)
he sales in the USA in Qtr 4 greater than $10.000orin the UK in Qtr 1

You might also like