Mẫu Báo cáo doanh số theo sản phẩm

̃Ư

̣ ̣

D LIÊU NHÂP

SAN PHÂM

KHACH HANG

̀ ́ SÔ TIÊN

QUÝ

NGAỲ

̉ ̉

Page 1 of 6

̉ ̉ 1/1/2012 San phâm 14 Fabrikam, Inc. 39,228,800.00 ₫ QUY 1́ ̉ ̉ 1/3/2012 San phâm 23 Alpine Ski House 83,657,600.00 ₫ QUY 1́ ̉ ̉ 1/4/2012 San phâm 18 Coho Winery 169,395,200.00 ₫ QUY 1́ ̉ ̉ 1/7/2012 San phâm 10 Southridge Video 166,441,600.00 ₫ QUY 1́ ̉ ̉ 1/11/2012 San phâm 7 Coho Winery 132,953,600.00 ₫ QUY 1́ ̉ ̉ 1/25/2012 San phâm 1 Contoso, Ltd 134,035,200.00 ₫ QUY 1́ ̉ ̉ 1/30/2012 San phâm 27 Southridge Video 57,657,600.00 ₫ QUY 1́ ̉ ̉ 2/4/2012 San phâm 30 City Power & Light 180,419,200.00 ₫ QUY 1́ ̉ ̉ 2/5/2012 San phâm 16 A. Datum Corporation 48,505,600.00 ₫ QUY 1́ ̉ ̉ 2/8/2012 San phâm 21 Alpine Ski House 111,696,000.00 ₫ QUY 1́ ̉ ̉ 2/10/2012 San phâm 6 City Power & Light 36,774,400.00 ₫ QUY 1́ ̉ ̉ 2/17/2012 San phâm 24 Coho Winery 113,859,200.00 ₫ QUY 1́ ̉ ̉ 2/22/2012 San phâm 28 Fabrikam, Inc. 72,675,200.00 ₫ QUY 1́ ̉ ̉ 2/24/2012 San phâm 22 City Power & Light 30,867,200.00 ₫ QUY 1́ ̉ ̉ 2/29/2012 San phâm 26 Humongous Insurance 113,443,200.00 ₫ QUY 1́ ̉ ̉ 3/1/2012 San phâm 15 City Power & Light 47,964,800.00 ₫ QUY 1́ ̉ ̉ 3/8/2012 San phâm 9 A. Datum Corporation 179,961,600.00 ₫ QUY 1́ ̉ ̉ 3/14/2012 San phâm 16 Alpine Ski House 74,755,200.00 ₫ QUY 1́ ̉ ̉ 3/31/2012 San phâm 28 City Power & Light 189,904,000.00 ₫ QUY 1́ ̉ ̉ 4/3/2012 San phâm 28 Southridge Video 207,708,800.00 ₫ QUY 2́ ̉ ̉ 4/9/2012 San phâm 2 Fabrikam, Inc. 172,016,000.00 ₫ QUY 2́ ̉ ̉ 4/10/2012 San phâm 30 A. Datum Corporation 107,827,200.00 ₫ QUY 2́ ̉ ̉ 4/11/2012 San phâm 25 Contoso, Ltd 196,060,800.00 ₫ QUY 2́ ̉ ̉ 4/11/2012 San phâm 15 Humongous Insurance 83,449,600.00 ₫ QUY 2́ ̉ ̉ 4/15/2012 San phâm 28 Coho Winery 160,659,200.00 ₫ QUY 2́ ̉ ̉ 5/3/2012 San phâm 21 Northwind Traders 47,091,200.00 ₫ QUY 2́ ̉ ̉ 5/4/2012 San phâm 30 Coho Winery 194,979,200.00 ₫ QUY 2́ ̉ ̉ 5/5/2012 San phâm 17 Humongous Insurance 76,793,600.00 ₫ QUY 2́ ̉ ̉ 5/5/2012 San phâm 28 Humongous Insurance 189,779,200.00 ₫ QUY 2́ ̉ ̉ 5/19/2012 San phâm 22 Humongous Insurance 103,209,600.00 ₫ QUY 2́ ̉ ̉ 5/22/2012 San phâm 8 A. Datum Corporation 190,652,800.00 ₫ QUY 2́ ̉ ̉ 5/31/2012 San phâm 16 Coho Winery 116,688,000.00 ₫ QUY 2́ ̉ ̉ 6/2/2012 San phâm 8 City Power & Light 69,097,600.00 ₫ QUY 2́ ̉ ̉ 6/2/2012 San phâm 3 Humongous Insurance 53,913,600.00 ₫ QUY 2́

SAN PHÂM

KHACH HANG

̀ ́ SÔ TIÊN

QUÝ

NGAỲ

̉ ̉

Page 2 of 6

̉ ̉ 6/4/2012 San phâm 13 Contoso, Ltd 92,435,200.00 ₫ QUY 2́ ̉ ̉ 6/9/2012 San phâm 10 Southridge Video 149,052,800.00 ₫ QUY 2́ ̉ ̉ 6/12/2012 San phâm 13 Fabrikam, Inc. 104,166,400.00 ₫ QUY 3́ ̉ ̉ 6/26/2012 San phâm 2 Contoso, Ltd 74,422,400.00 ₫ QUY 3́ ̉ ̉ 6/29/2012 San phâm 22 Southridge Video 23,795,200.00 ₫ QUY 3́ ̉ ̉ 7/2/2012 San phâm 14 Alpine Ski House 76,876,800.00 ₫ QUY 3́ ̉ ̉ 7/6/2012 San phâm 14 Coho Winery 147,347,200.00 ₫ QUY 3́ ̉ ̉ 7/6/2012 San phâm 2 City Power & Light 96,553,600.00 ₫ QUY 3́ ̉ ̉ 7/8/2012 San phâm 5 Fabrikam, Inc. 126,422,400.00 ₫ QUY 3́ ̉ ̉ 7/10/2012 San phâm 9 Alpine Ski House 49,795,200.00 ₫ QUY 3́ ̉ ̉ 7/15/2012 San phâm 13 Southridge Video 114,732,800.00 ₫ QUY 3́ ̉ ̉ 7/16/2012 San phâm 8 Fabrikam, Inc. 40,518,400.00 ₫ QUY 3́ ̉ ̉ 7/19/2012 San phâm 28 Contoso, Ltd 151,424,000.00 ₫ QUY 3́ ̉ ̉ 7/29/2012 San phâm 26 A. Datum Corporation 193,273,600.00 ₫ QUY 3́ ̉ ̉ 8/19/2012 San phâm 26 Fabrikam, Inc. 122,054,400.00 ₫ QUY 3́ ̉ ̉ 8/19/2012 San phâm 6 Northwind Traders 85,238,400.00 ₫ QUY 3́ ̉ ̉ 8/20/2012 San phâm 13 A. Datum Corporation 26,416,000.00 ₫ QUY 3́ ̉ ̉ 8/20/2012 San phâm 23 A. Datum Corporation 161,075,200.00 ₫ QUY 3́ ̉ ̉ 8/24/2012 San phâm 2 Humongous Insurance 114,150,400.00 ₫ QUY 3́ ̉ ̉ 8/24/2012 San phâm 5 Southridge Video 144,435,200.00 ₫ QUY 3́ ̉ ̉ 8/25/2012 San phâm 20 Fabrikam, Inc. 92,643,200.00 ₫ QUY 3́ ̉ ̉ 8/27/2012 San phâm 13 City Power & Light 147,680,000.00 ₫ QUY 3́ ̉ ̉ 8/30/2012 San phâm 8 Humongous Insurance 90,396,800.00 ₫ QUY 3́ ̉ ̉ 9/1/2012 San phâm 25 Alpine Ski House 42,265,600.00 ₫ QUY 3́ ̉ ̉ 9/17/2012 San phâm 20 Contoso, Ltd 48,422,400.00 ₫ QUY 3́ ̉ ̉ 9/22/2012 San phâm 18 Humongous Insurance 126,672,000.00 ₫ QUY 3́ ̉ ̉ 9/25/2012 San phâm 19 Coho Winery 173,555,200.00 ₫ QUY 3́ ̉ ̉ 9/29/2012 San phâm 11 Alpine Ski House 122,137,600.00 ₫ QUY 3́ ̉ ̉ 9/30/2012 San phâm 25 Humongous Insurance 32,822,400.00 ₫ QUY 3́ ̉ ̉ 10/2/2012 San phâm 29 City Power & Light 35,651,200.00 ₫ QUY 4́ ̉ ̉ 10/5/2012 San phâm 11 Fabrikam, Inc. 118,892,800.00 ₫ QUY 4́ ̉ ̉ 10/6/2012 San phâm 21 Coho Winery 171,475,200.00 ₫ QUY 4́ ̉ ̉ 10/14/2012 San phâm 11 A. Datum Corporation 184,870,400.00 ₫ QUY 4́ ̉ ̉ 10/14/2012 San phâm 23 City Power & Light 196,310,400.00 ₫ QUY 4́ ̉ ̉ 11/9/2012 San phâm 14 Southridge Video 129,584,000.00 ₫ QUY 4́ ̉ ̉ 11/13/2012 San phâm 17 A. Datum Corporation 88,982,400.00 ₫ QUY 4́

NGAỲ

SAN PHÂM

KHACH HANG

̀ ́ SÔ TIÊN

QUÝ

̉ ̉

Page 3 of 6

̉ ̉ 11/17/2012 San phâm 6 Alpine Ski House 113,110,400.00 ₫ QUY 4́ ̉ ̉ 11/22/2012 San phâm 1 Coho Winery 139,942,400.00 ₫ QUY 4́ ̉ ̉ 11/25/2012 San phâm 30 Fabrikam, Inc. 207,833,600.00 ₫ QUY 4́ ̉ ̉ 11/25/2012 San phâm 26 Northwind Traders 176,009,600.00 ₫ QUY 4́ ̉ ̉ 11/27/2012 San phâm 11 Contoso, Ltd 164,944,000.00 ₫ QUY 4́ ̉ ̉ 11/30/2012 San phâm 30 Northwind Traders 169,228,800.00 ₫ QUY 4́ ̉ ̉ 12/2/2012 San phâm 13 Humongous Insurance 129,209,600.00 ₫ QUY 4́ ̉ ̉ 12/5/2012 San phâm 3 Contoso, Ltd 102,876,800.00 ₫ QUY 4́ ̉ ̉ 12/5/2012 San phâm 3 Southridge Video 177,923,200.00 ₫ QUY 4́ ̉ ̉ 12/10/2012 San phâm 24 Northwind Traders 93,766,400.00 ₫ QUY 4́ ̉ ̉ 12/21/2012 San phâm 7 Humongous Insurance 151,840,000.00 ₫ QUY 4́ ̉ ̉ 12/24/2012 San phâm 17 Fabrikam, Inc. 172,473,600.00 ₫ QUY 4́ ̉ ̉ 12/26/2012 San phâm 26 Alpine Ski House 203,465,600.00 ₫ QUY 4́ ̉ ̉ 1/3/2013 San phâm 19 Fabrikam, Inc. 166,899,200.00 ₫ QUY 1́ ̉ ̉ 1/4/2013 San phâm 22 A. Datum Corporation 78,166,400.00 ₫ QUY 1́

ợ ́

̣ ̉ ̉ ̣ ̣ ̣ ̉ ̣ ̣

́

BAO CAO KINH DOANH

ng. Vi du, ke o tr ̃

́ ̀

́ ̣ ư

̀ ươ

QUÝ

Sum - SỐ TIỀN

́ơ

̉ ̣ ̉ ̣ ̣ ̣ ̉ ̉ ̉ ̉ ̣ ̣ ̉ ̣

Total Result

MEO: ̀ ́ ơ Tu y chinh PivotTable na y cho phu h p v i nhu câ u cua ban! Chon môt ô trong ́ ́ ̀ ở ươ ngăn ta c vu, PivotTable đê ki ch hoat ngăn Danh sa ch Tr ng PivotTable. Sau đo ̀ ̀ ́ ươ ươ ke o đê thêm, loai bo hoăc să p xê p lai ca c tr ng San phâm lên ́ ̀ trên tr ng Kha ch ha ng đê co ca i nhi n kha c. Đê câp nhât d liêu PivotTable, ha y ̀ ́ bâ m phai chuôt trong PivotTable sau đo bâ m La m m i. 2013 QÚY 1

QUÝ 4

QUÝ 3

Years 2012 QÚY 1

QUÝ 2

KHÁCH HÀNG

SẢN PHẨM Sản phẩm 1

###

Coho Winery Contoso, Ltd

139,942,400.00 ₫ 134,035,200.00 ₫

Sản phẩm 10

Southridge Video

###

315,494,400.00 ₫

Sản phẩm 11

###

A. Datum Corporation Alpine Ski House Contoso, Ltd Fabrikam, Inc.

### ###

184,870,400.00 ₫ 122,137,600.00 ₫ 164,944,000.00 ₫ 118,892,800.00 ₫

Sản phẩm 13

26,416,000.00 ₫ ###

92,435,200.00 ₫

###

A. Datum Corporation City Power & Light Contoso, Ltd Fabrikam, Inc. Humongous Insurance Southridge Video

###

26,416,000.00 ₫ 147,680,000.00 ₫ 92,435,200.00 ₫ 104,166,400.00 ₫ 129,209,600.00 ₫ 114,732,800.00 ₫

Sản phẩm 14

76,876,800.00 ₫ ###

39,228,800.00 ₫

Alpine Ski House Coho Winery Fabrikam, Inc. Southridge Video

###

76,876,800.00 ₫ 147,347,200.00 ₫ 39,228,800.00 ₫ 129,584,000.00 ₫

Sản phẩm 15

City Power & Light 47,964,800.00 ₫ Humongous Insurance

83,449,600.00 ₫

47,964,800.00 ₫ 83,449,600.00 ₫

Sản phẩm 16

A. Datum Corporation48,505,600.00 ₫ 74,755,200.00 ₫ Alpine Ski House Coho Winery

###

48,505,600.00 ₫ 74,755,200.00 ₫ 116,688,000.00 ₫

Sản phẩm 17

88,982,400.00 ₫ ###

A. Datum Corporation Fabrikam, Inc. Humongous Insurance

76,793,600.00 ₫

88,982,400.00 ₫ 172,473,600.00 ₫ 76,793,600.00 ₫

Sản phẩm 18

###

Coho Winery Humongous Insurance

###

169,395,200.00 ₫ 126,672,000.00 ₫

Sản phẩm 19

###

Coho Winery Fabrikam, Inc.

173,555,200.00 ₫ ### 166,899,200.00 ₫

Sản phẩm 2

96,553,600.00 ₫ 74,422,400.00 ₫

###

City Power & Light Contoso, Ltd Fabrikam, Inc. Humongous Insurance

###

96,553,600.00 ₫ 74,422,400.00 ₫ 172,016,000.00 ₫ 114,150,400.00 ₫

Sản phẩm 20

Contoso, Ltd Fabrikam, Inc.

48,422,400.00 ₫ 92,643,200.00 ₫

Sản phẩm 21

###

Alpine Ski House Coho Winery Northwind Traders

111,696,000.00 ₫ 171,475,200.00 ₫ 47,091,200.00 ₫

47,091,200.00 ₫

Sản phẩm 22

A. Datum Corporation City Power & Light 30,867,200.00 ₫ Humongous Insurance

###

78,166,400.00 ₫ 78,166,400.00 ₫ 30,867,200.00 ₫ 103,209,600.00 ₫

Page 4 of 6

ợ ́

ng. Vi du, ke o tr ̃

́ ̀

́ ̣ ư

̀ ươ

QUÝ

Sum - SỐ TIỀN

́ơ

Years 2012

̣ ̉ ̉ ̣ ̣ ̣ ̉ ̣ ̣ ̉ ̣ ̉ ̣ ̣ ̣ ̉ ̉ ̉ ̉ ̣ ̣ ̉ ̣

Total Result

Southridge Video

23,795,200.00 ₫

Sản phẩm 23

###

83,657,600.00 ₫

A. Datum Corporation Alpine Ski House City Power & Light

###

161,075,200.00 ₫ 83,657,600.00 ₫ 196,310,400.00 ₫

Sản phẩm 24

###

Coho Winery Northwind Traders

93,766,400.00 ₫

113,859,200.00 ₫ 93,766,400.00 ₫

Sản phẩm 25

42,265,600.00 ₫

###

32,822,400.00 ₫

Alpine Ski House Contoso, Ltd Humongous Insurance

42,265,600.00 ₫ 196,060,800.00 ₫ 32,822,400.00 ₫

Sản phẩm 26

###

A. Datum Corporation Alpine Ski House Fabrikam, Inc. Humongous Insurance Northwind Traders

###

193,273,600.00 ₫ 203,465,600.00 ₫ 122,054,400.00 ₫ 113,443,200.00 ₫ 176,009,600.00 ₫

Sản phẩm 27

Southridge Video 57,657,600.00 ₫

57,657,600.00 ₫

Sản phẩm 28

###

72,675,200.00 ₫

City Power & Light Coho Winery Contoso, Ltd Fabrikam, Inc. Humongous Insurance Southridge Video

### ###

189,904,000.00 ₫ 160,659,200.00 ₫ 151,424,000.00 ₫ 72,675,200.00 ₫ 189,779,200.00 ₫ 207,708,800.00 ₫

Sản phẩm 29

City Power & Light

35,651,200.00 ₫

Sản phẩm 3

###

53,913,600.00 ₫

Contoso, Ltd Humongous Insurance Southridge Video

###

102,876,800.00 ₫ 53,913,600.00 ₫ 177,923,200.00 ₫

Sản phẩm 30

###

A. Datum Corporation City Power & Light Coho Winery Fabrikam, Inc. Northwind Traders

### ###

107,827,200.00 ₫ 180,419,200.00 ₫ 194,979,200.00 ₫ 207,833,600.00 ₫ 169,228,800.00 ₫

Sản phẩm 5

### ###

Fabrikam, Inc. Southridge Video

126,422,400.00 ₫ 144,435,200.00 ₫

Sản phẩm 6

###

Alpine Ski House City Power & Light 36,774,400.00 ₫ Northwind Traders

85,238,400.00 ₫

113,110,400.00 ₫ 36,774,400.00 ₫ 85,238,400.00 ₫

Sản phẩm 7

###

Coho Winery Humongous Insurance

###

132,953,600.00 ₫ 151,840,000.00 ₫

Sản phẩm 8

### 69,097,600.00 ₫

A. Datum Corporation City Power & Light Fabrikam, Inc. Humongous Insurance

40,518,400.00 ₫ 90,396,800.00 ₫

190,652,800.00 ₫ 69,097,600.00 ₫ 40,518,400.00 ₫ 90,396,800.00 ₫

Sản phẩm 9

###

A. Datum Corporation Alpine Ski House

Total Result

###

49,795,200.00 ₫ ###

###

179,961,600.00 ₫ 49,795,200.00 ₫ ###

###

Page 5 of 6

́

̃Ư

DANH SACH D LIÊU

SAN PHÂM

KHACH HANG

́ ơ

San phâm 1

A. Datum Corporation

́ ́

MEO: ̀ Đê thêm môt san phâm hoăc kha ch ha ng m i, ha y bă t ́ ̀ ở ự ươ đâ u nhâp bang d đông m rông khi i đây va no se t ́ ban nhâ n phi m Enter hoăc phi m Tab.

San phâm 2

Adventure Works

San phâm 3

Alpine Ski House

San phâm 4

Blue Yonder Airlines

San phâm 5

City Power & Light

San phâm 6

Coho Vineyard

San phâm 7

Coho Winery

San phâm 8

Coho Vineyard & Winery

San phâm 9

Contoso, Ltd

San phâm 10

Contoso Pharmaceuticals

San phâm 11

Consolidated Messenger

San phâm 12

Fabrikam, Inc.

San phâm 13

Fourth Coffee

San phâm 14

́ Viên Thiêt kê Đô hoa

San phâm 15

Humongous Insurance

San phâm 16

Litware, Inc.

San phâm 17

Lucerne Publishing

San phâm 18

Margie's Travel

San phâm 19

Northwind Traders

San phâm 20

Proseware, Inc.

ươ

San phâm 21

̃ ̀ ng My thuât

San phâm 22

Southridge Video

San phâm 23

Tailspin Toys

San phâm 24

Trey Research

San phâm 25

Công ty Điên thoai

San phâm 26

Wide World Importers

San phâm 27

Wingtip Toys

San phâm 28

Woodgrove Bank

San phâm 29

San phâm 30

Page 6 of 6

̣ ̉ ̉ ̉ ̣ ̉ ̉ ̣ ̉ ̉ ̣ ̉ ̣ ̣ ̣ ̣ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̣ ̣ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̣ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̣ ̣ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉ ̉