给我一份适合练习excel数据透视表的数据
时间: 2024-04-03 14:34:33 浏览: 22
好的,以下是一份适合练习Excel数据透视表的数据:
| Order Date | Region | Category | Product | Sales |
|------------|--------|----------|---------|-------|
| 1/1/2020 | East | Furniture | Chair | $100 |
| 1/2/2020 | West | Office | Desk | $200 |
| 1/3/2020 | South | Technology| Laptop | $500 |
| 1/4/2020 | East | Furniture | Table | $300 |
| 1/5/2020 | North | Office | Chair | $150 |
| 1/6/2020 | South | Technology| Printer | $1000 |
| 1/7/2020 | West | Furniture | Sofa | $600 |
| 1/8/2020 | East | Office | Chair | $120 |
| 1/9/2020 | North | Technology| Phone | $800 |
| 1/10/2020 | South | Office | Desk | $250 |
这个数据包含了10个订单,每个订单包含了订单日期、地区、产品类别、产品名称以及销售额。你可以使用Excel数据透视表来分析这些数据,例如按地区汇总销售额,或者按产品类别汇总销售额等等。