Order ID Order Amount Discount % Offer Price
44017 $88.68 10%
24855 $10.95 0%
37211 $99.98 10%
14623 $33.88 5%
36869 $106.29 20%
37376 $94.12 10%
45661 $31.00 #N/A
27306 $26.65 #N/A
17827 $102.83 #N/A
31195 $23.56 #N/A
48712 $196.66 #N/A
20859 $86.89 #N/A
21518 $88.38 #N/A
31272 $55.19 #N/A
37456 $37.05 #N/A
20901 $55.94 #N/A
17276 $120.44 #N/A
20295 $106.00 #N/A
46459 $31.24 #N/A
26197 $30.42 #N/A
42834 $190.85 #N/A
25575 $91.92 #N/A
39470 $121.40 #N/A
11164 $95.50 #N/A
45926 $112.32 #N/A
Order Amount Discount Tasks What is the applicable discount for the order amount?
0 0% What is the final offer price?
25 5%
50 10%
100 20%
0 0%
25 5%
50 10%
100 20%
1 2 3 4 5
XSmall Small Medium Large XLarge
1 Socks $4.00 $4.25 $4.50 $4.75 $5.00
2 Shorts $12.00 $12.50 $13.00 $13.50 $14.00
3 Pants $24.00 $25.00 $26.00 $27.00 $28.00
4 T-Shirt $15.00 $15.50 $16.00 $16.50 $17.00
5 Sweater $30.00 $31.00 $32.00 $33.00 $34.00
Product: Size: Price
Pants Small = 25
Tasks What is the final price for the product?
Date Buyer Type Amount Tasks
1-Jan Mom Fuel ₹ 74.00
15-Jan Mom Food ₹ 235.00
17-Jan Dad Sports ₹ 20.00
21-Jan Kelly Books ₹ 125.00
2-Feb Mom Food ₹ 235.00
20-Feb Kelly Music ₹ 20.00
25-Feb Kelly Tickets ₹ 125.00
...and the column field
provides a condition....
The row field provides
a condition....
...and the value field
sums them up.
How each buyer spent on each type?
Date - all -
Sum of Amount Type
Buyer Books Food Fuel Music
Sports Tickets Total Result
Dad ₹ 20.00 ₹ 20.00
Kelly ₹ 125.00 ₹ 20.00 ₹ 125.00 ₹ 270.00
Mom ₹ 470.00 ₹ 74.00 ₹ 544.00
Total Result ₹ 125.00 ₹ 470.00 ₹ 74.00 ₹ 20.00 ₹ 20.00 ₹ 125.00 ₹ 834.00
₹500.00
₹450.00
₹400.00
₹350.00
Type Books
₹300.00 Food
₹250.00 Fuel
Music
₹200.00 Sports
₹150.00 Tickets
...and the column field
provides a condition....
₹100.00
₹50.00
₹-
Dad Kelly Mom Total Result
...and the value field
sums them up.
Season Sales rep Product Units sold
Winter Jenny Oranges 300
Winter George Grapefruit 200
Winter Dave Apples 400
Winter Jenny Bananas 300
Winter George Oranges 800 Season
Winter Dave Grapefruit 400 Fall Spring
Winter Jenny Apples 200 5425 4760
Winter George Bananas 300
Winter Dave Oranges 450 20000
Winter Jenny Grapefruit 230 18000
Winter George Apples 120
16000
Winter Dave Bananas 400
Spring Jenny Beets 210 14000
Spring George Potatoes 300 12000
S
Spring Dave Lettuce 400
10000 S
Spring Jenny Radishes 230 W
Spring George Beets 900 8000 T
Spring Dave Potatoes 300 6000
Spring Jenny Lettuce 200
4000
Spring George Radishes 1000
Spring Dave Beets 220 2000
Spring Jenny Potatoes 400 0
Spring George Lettuce 200 5425
Spring Dave Radishes 400
Summer Jenny Blueberries 100
Summer George Strawberri 30
Summer Dave Grapes 123
Summer Jenny Pumpkins 300
Summer George Blueberries 350
Summer Dave Strawberri 230
Summer Jenny Grapes 120
Summer George Pumpkins 640
Summer Dave Blueberries 530
Summer Jenny Strawberri 560
Summer George Grapes 240
Summer Dave Pumpkins 250
Fall Jenny Squash 62
Fall George Zucchini 600
Fall Dave Apples 340
Fall Jenny Oranges 205
Fall George Squash 500
Fall Dave Zucchini 403
Fall Jenny Apples 503
Fall George Oranges 2000
Fall Dave Squash 140
Fall Jenny Zucchini 502
Fall George Apples 120
Fall Dave Oranges 50
Tasks How many units sold as per the season?
Who sold the most during the fall?
SummerWinter Total Result
3473 4100 17758
Spring
Summer
Winter
Total Result
5425
