案例20－图表分析－sales analysis.xls

文档介绍：salesperson (全部)
product (全部)
region (全部)

period
acctcode 数据 1 2 3 4
1102 求和项:debit 76, 80, 75,
求和项:credit - - -
最大值项:balance 6,076, 6,157, 6,232,
1144 求和项:debit 235, 227, 250, 219,
求和项:credit - 76, 80, 75,
最大值项:balance 835, 986, 1,156, 1,301,
4101 求和项:debit - - - -
求和项:credit 235, 227, 250, 219,
最大值项:balance 235, 463, 713, 933,

Jan Feb Mar Apr May
AR Collection Rate 0% 9% 10% 9% 11%
Revenue
Receipt 0






















5 6 7 8 9 10
91, 74, 72, 72, 75, 83,
- - - - - -
6,324, 6,399, 6,471, 6,544, 6,619, 6,703,
226, 240, 226, 234, 223, 240,
91, 74, 72, 72, 75, 83,
1,441, 1,610, 1,755, 1,916, 2,065, 2,232,
- - - - - -
226, 240, 226, 234, 223, 240,
1,160, 1,400, 1,626, 1,861, 2,085, 2,326,

Jun Jul Aug Sep Oct Nov
9% 9% 9% 9% 10% 9%
























11
77,
-
6,781,
222,
77,
2,374,
-
222,
2,548,

Dec
9%



















salesperson (全部)
product (全部)
region (全部)

period
acctcode 数据 1 2 3 4 5
1102 求和项:debit 76, 80, 75, 91,
求和项:credit - - - -
最大值项:balance 6,076, 6,157, 6,232, 6,324,
1144 求和项:debit 235, 227, 2