分类汇总销售记录

销售ID,产品名称,单价,数量,销售日期,销售额,优惠额,实际收款

11,眼部滋养凝露,90,12,2012/7/3,1080,,1080

25,眼部滋养凝露,90,85,2012/7/5,7650,20,7630

39,眼部滋养凝露,90,53,2012/7/6,4770,10,4760

53,眼部滋养凝露,90,32,2012/7/7,2880,,2880

67,眼部滋养凝露,90,21,2012/7/8,1890,,1890

81,眼部滋养凝露,90,33,2012/7/9,2970,,2970

95,眼部滋养凝露,90,35,2012/7/10,3150,,3150

,眼部滋养凝露平均值,,38.71428571,,3484.285714,,

,眼部滋养凝露汇总,,271,,24390,,

4,透白亮泽化妆露,90,3,2012/7/1,270,,270

18,透白亮泽化妆露,90,60,2012/7/4,5400,,5400

32,透白亮泽化妆露,90,18,2012/7/5,1620,,1620

46,透白亮泽化妆露,90,15,2012/7/7,1350,,1350

60,透白亮泽化妆露,90,19,2012/7/8,1710,,1710

74,透白亮泽化妆露,90,20,2012/7/9,1800,,1800

88,透白亮泽化妆露,90,33,2012/7/10,2970,,2970

,透白亮泽化妆露平均值,,24,,2160,,

,透白亮泽化妆露汇总,,168,,15120,,

14,晒后修复霜,50,40,2012/7/3,,,0

28,晒后修复霜,50,25,2012/7/5,1250,,1250

42,晒后修复霜,50,11,2012/7/7,550,,550

56,晒后修复霜,50,10,2012/7/8,500,,500

70,晒后修复霜,50,23,2012/7/9,1150,,1150

84,晒后修复霜,50,36,2012/7/10,1800,,1800

,晒后修复霜平均值,,24.16666667,,1050,,

,晒后修复霜汇总,,145,,5250,,

8,散粉,445,12,2012/7/2,5340,,5340

22,散粉,445,18,2012/7/4,8010,45,7965

23,散粉,445,50,2012/7/6,22250,,22250

50,散粉,445,27,2012/7/7,12015,8,12007

86,散粉,445,23,2012/7/8,10235,5,10230

64,散粉,445,25,2012/7/9,11125,,11125

37,散粉,445,32,2012/7/10,14240,15,14225

,散粉平均值,,26.71428571,,11887.85714,,

,散粉汇总,,187,,83215,,

5,柔和防晒露SPF8,190,5,2012/7/2,950,,950

19,柔和防晒露SPF8,190,52,2012/7/4,9880,,9880

33,柔和防晒露SPF8,190,19,2012/7/5,3610,,3610

51,柔和防晒露SPF8,190,63,2012/7/7,11970,20,11950

61,柔和防晒露SPF8,190,16,2012/7/8,3040,,3040

75,柔和防晒露SPF8,190,21,2012/7/9,3990,10,3980

89,柔和防晒露SPF8,190,32,2012/7/10,6080,,6080

,柔和防晒露SPF8平均值,,29.71428571,,5645.714286,,

,柔和防晒露SPF8汇总,,208,,39520,,

2,清新水质凝露,348,20,2012/7/1,6960,,6960

16,清新水质凝露,348,18,2012/7/3,6264,25,6239

78,清新水质凝露,348,30,2012/7/5,10440,18,10422

44,清新水质凝露,348,18,2012/7/7,6264,,6264

58,清新水质凝露,348,14,2012/7/8,4872,,4872

72,清新水质凝露,348,26,2012/7/9,9048,,9048

47,清新水质凝露,348,35,2012/7/10,12180,,12180

,清新水质凝露平均值,,23,,8004,,

,清新水质凝露汇总,,161,,56028,,

6,清透平衡露,69,9,2012/7/2,621,21,600

20,清透平衡露,69,14,2012/7/4,966,,966

34,清透平衡露,69,12,2012/7/5,828,,828

48,清透平衡露,69,25,2012/7/7,1725,9,1716

62,清透平衡露,69,22,2012/7/8,1518,,1518

76,清透平衡露,69,22,2012/7/9,1518,,1518

90,清透平衡露,69,31,2012/7/10,2139,,2139

,清透平衡露平均值,,19.28571429,,1330.714286,,

,清透平衡露汇总,,135,,9315,,

10,女士香水,260,20,2012/7/2,5200,,5200

24,女士香水,260,36,2012/7/5,9360,,9360

38,女士香水,260,52,2012/7/6,13520,,13520

52,女士香水,260,26,2012/7/7,6760,,6760

66,女士香水,260,24,2012/7/8,6240,,6240

80,女士香水,260,25,2012/7/9,6500,,6500

94,女士香水,260,36,2012/7/10,9360,,9360

,女士香水平均值,,31.28571429,,8134.285714,,

,女士香水汇总,,219,,56940,,

13,嫩白眼霜,200,20,2012/7/3,4000,20,3980

27,嫩白眼霜,200,21,2012/7/5,4200,20,4180

41,嫩白眼霜,200,30,2012/7/6,6000,10,5990

55,嫩白眼霜,200,20,2012/7/7,4000,,4000

69,嫩白眼霜,200,28,2012/7/9,5600,10,5590

83,嫩白眼霜,200,35,2012/7/10,7000,10,6990

,嫩白眼霜平均值,,25.66666667,,5133.333333,,

,嫩白眼霜汇总,,154,,30800,,

9,男士香水,288,14,2012/7/2,4032,,4032

92,男士香水,288,35,2012/7/5,10080,,10080

36,男士香水,288,51,2012/7/6,14688,20,14668

30,男士香水,288,54,2012/7/7,15552,10,15542

65,男士香水,288,23,2012/7/8,6624,8,6616

79,男士香水,288,23,2012/7/9,6624,,6624

93,男士香水,288,30,2012/7/10,8640,,8640

,男士香水平均值,,32.85714286,,9462.857143,,

,男士香水汇总,,230,,66240,,

7,俊仕剃须膏,67,8,2012/7/2,536,,536

21,俊仕剃须膏,67,19,2012/7/4,1273,,1273

35,俊仕剃须膏,67,14,2012/7/5,938,,938

49,俊仕剃须膏,67,28,2012/7/7,1876,,1876

63,俊仕剃须膏,67,28,2012/7/8,1876,,1876

77,俊仕剃须膏,67,24,2012/7/9,1608,,1608

91,俊仕剃须膏,67,35,2012/7/10,2345,,2345

,俊仕剃须膏平均值,,22.28571429,,1493.142857,,

,俊仕剃须膏汇总,,156,,10452,,

12,净白亮泽化妆露,98,35,2012/7/3,3430,,3430

26,净白亮泽化妆露,98,40,2012/7/5,3920,,3920

40,净白亮泽化妆露,98,12,2012/7/6,1176,,1176

54,净白亮泽化妆露,98,21,2012/7/7,2058,,2058

68,净白亮泽化妆露,98,20,2012/7/9,1960,,1960

82,净白亮泽化妆露,98,34,2012/7/10,3332,,3332

,净白亮泽化妆露平均值,,27,,2646,,

,净白亮泽化妆露汇总,,162,,15876,,

1,紧肤膜,250,15,2012/7/1,3750,,3750

15,紧肤膜,250,15,2012/7/3,3750,,3750

29,紧肤膜,250,20,2012/7/5,5000,10,4990

43,紧肤膜,250,17,2012/7/7,4250,,4250

57,紧肤膜,250,12,2012/7/8,3000,,3000

71,紧肤膜,250,25,2012/7/9,6250,,6250

85,紧肤膜,250,37,2012/7/10,9250,,9250

,紧肤膜平均值,,20.14285714,,5035.714286,,

,紧肤膜汇总,,141,,35250,,

3,活肤修复霜,165,10,2012/7/1,1650,,1650

17,活肤修复霜,165,25,2012/7/4,4125,32,4093

31,活肤修复霜,165,10,2012/7/5,1650,,1650

45,活肤修复霜,165,13,2012/7/7,2145,