Excel Exporting Template
Exporting pivot table with template
dollar_sales - sum | dollar_sales - count |
2004
|
2005
|
Total
|
||||||||||
Q3
|
Q4
|
Total
|
Q1
|
Total
|
|||||||||
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
||
AV Stores, Co.
|
Classic Cars
|
|
0
|
34737.87
|
11
|
34737.87
|
11
|
|
0
|
|
0
|
34737.87
|
11
|
Ships
|
|
0
|
19186.06
|
7
|
19186.06
|
7
|
|
0
|
|
0
|
19186.06
|
7
|
|
Trains
|
|
0
|
7873.58
|
3
|
7873.58
|
3
|
|
0
|
|
0
|
7873.58
|
3
|
|
Vintage Cars
|
|
0
|
38186.89
|
14
|
38186.89
|
14
|
|
0
|
|
0
|
38186.89
|
14
|
|
Total
|
|
0
|
99984.4
|
35
|
99984.4
|
35
|
|
0
|
|
0
|
99984.4
|
35
|
|
Alpha Cognac
|
Ships
|
|
0
|
|
0
|
|
0
|
12432.32
|
5
|
12432.32
|
5
|
12432.32
|
5
|
Total
|
|
0
|
|
0
|
|
0
|
12432.32
|
5
|
12432.32
|
5
|
12432.32
|
5
|
|
Amica Models & Co.
|
Classic Cars
|
26424.11
|
4
|
|
0
|
26424.11
|
4
|
|
0
|
|
0
|
26424.11
|
4
|
Ships
|
6251.22
|
3
|
|
0
|
6251.22
|
3
|
|
0
|
|
0
|
6251.22
|
3
|
|
Trains
|
2018.72
|
1
|
|
0
|
2018.72
|
1
|
|
0
|
|
0
|
2018.72
|
1
|
|
Trucks and Buses
|
2352
|
1
|
|
0
|
2352
|
1
|
|
0
|
|
0
|
2352
|
1
|
|
Vintage Cars
|
45177.18
|
17
|
|
0
|
45177.18
|
17
|
|
0
|
|
0
|
45177.18
|
17
|
|
Total
|
82223.23
|
26
|
|
0
|
82223.23
|
26
|
|
0
|
|
0
|
82223.23
|
26
|
|
Anna's Decorations, Ltd
|
Classic Cars
|
|
0
|
|
0
|
|
0
|
18187.89
|
4
|
18187.89
|
4
|
18187.89
|
4
|
Trucks and Buses
|
|
0
|
|
0
|
|
0
|
27396.76
|
9
|
27396.76
|
9
|
27396.76
|
9
|
|
Vintage Cars
|
|
0
|
|
0
|
|
0
|
11347.65
|
6
|
11347.65
|
6
|
11347.65
|
6
|
|
Total
|
|
0
|
|
0
|
|
0
|
56932.3
|
19
|
56932.3
|
19
|
56932.3
|
19
|
|
Atelier graphique
|
Motorcycles
|
6066.78
|
2
|
|
0
|
6066.78
|
2
|
|
0
|
|
0
|
6066.78
|
2
|
Vintage Cars
|
|
0
|
1676.14
|
1
|
1676.14
|
1
|
|
0
|
|
0
|
1676.14
|
1
|
|
Total
|
6066.78
|
2
|
1676.14
|
1
|
7742.92
|
3
|
|
0
|
|
0
|
7742.92
|
3
|
|
Total
|
88290.01
|
28
|
101660.54
|
36
|
189950.55
|
64
|
69364.62
|
24
|
69364.62
|
24
|
259315.17
|
88
|
|