Saving information from a table into Excel does not always result in useful information. See how nextanalytics makes it easy to extract from a crosstab to a file suitable for reading into Excel, ready for processing.
Save results for reading into Excel
Script
-
adddata , actuals.csv
-
savepagetocsvpivot,actuals-as-pivot2.csv,True
This is example data
that will be used to show how to put data in a format to create an
Excel PivotTable. The file will be in your data directory under the name of actuals-as-pivot2.csv. If you open that with Excel, and then convert the data to PivotTables, you'll get exactly what you need. This format is also useful for importing into other applications since it is what some companies might refer to as a fact-table format or tuple based format.
| Name |
Region |
Position |
01/06 |
02/06 |
03/06 |
04/06 |
05/06 |
06/06 |
07/06 |
08/06 |
09/06 |
10/06 |
11/06 |
12/06 |
| Ted Burton |
Central |
Account Manager |
33,900 |
62,100 |
106,200 |
37,100 |
115,600 |
151,700 |
58,500 |
102,400 |
177,700 |
83,000 |
133,600 |
210,400 |
| Nell Gordon |
Central |
Sr. Account Manager |
87,200 |
172,700 |
300,100 |
85,700 |
49,400 |
47,500 |
68,700 |
11,400 |
123,200 |
109,200 |
202,100 |
152,400 |
| Bonnie Mills |
Central |
Account Manager |
25,800 |
75,100 |
77,300 |
71,500 |
32,900 |
14,700 |
44,000 |
13,400 |
227,000 |
98,400 |
120,000 |
173,800 |
| Juan Perez |
Central |
Account Manager |
25,000 |
32,900 |
117,600 |
67,900 |
104,600 |
62,700 |
55,600 |
54,800 |
18,000 |
18,500 |
109,600 |
233,000 |
| Jonathan Ryan |
Central |
Account Representative |
0 |
0 |
0 |
0 |
0 |
0 |
16,600 |
32,000 |
34,800 |
6,700 |
4,800 |
84,800 |
| Marcus Saul |
Central |
Account Manager |
25,000 |
46,000 |
22,500 |
25,800 |
76,400 |
199,200 |
11,100 |
67,800 |
203,300 |
44,100 |
65,300 |
193,500 |
| Jerry Wong |
Central |
Sr. Account Manager |
99,000 |
159,700 |
63,200 |
7,200 |
169,700 |
286,200 |
83,700 |
231,600 |
251,700 |
155,600 |
208,000 |
314,900 |
| Will Hill |
Federal |
Account Representative |
16,200 |
15,700 |
22,300 |
13,500 |
43,100 |
29,900 |
11,900 |
46,600 |
44,200 |
32,000 |
6,100 |
122,600 |
| Gil Jacobs |
Federal |
Account Manager |
57,600 |
42,500 |
88,200 |
23,600 |
74,700 |
186,400 |
66,400 |
113,700 |
214,900 |
18,300 |
142,700 |
198,700 |
| Larry Kelley |
Federal |
Account Manager |
1,200 |
22,900 |
97,400 |
68,700 |
99,200 |
38,100 |
86,900 |
107,600 |
31,700 |
63,900 |
109,500 |
203,800 |
"text_Data","rowlabel_Name","text_Region","text_Position","numeric_Value
"01/06","Ted Burton","Central","Account Manager","33900"
"01/06","Nell Gordon","Central","Sr. Account Manager","87200"
"01/06","Bonnie Mills","Central","Account Manager","25800"
"01/06","Juan Perez","Central","Account Manager","25000"
"01/06","Jonathan Ryan","Central","Account Representative","0"
"01/06","Marcus Saul","Central","Account Manager","25000"
"01/06","Jerry Wong","Central","Sr. Account Manager","99000"
"01/06","Will Hill","Federal","Account Representative","16200"
"01/06","Gil Jacobs","Federal","Account Manager","57600"
"01/06","Larry Kelley","Federal","Account Manager","1200"
"01/06","Priscilla Morris","Federal","Sr. Account Manager","77800"
"01/06","Phillip White","Federal","Account Manager","62300"
"01/06","Anne Grenier","International","Account Manager","70200"
"01/06","John Wells","International","Sr. Account Manager","42000"
"01/06","Bill Wright","International","Account Manager","19100"
"01/06","Mike Chang","Northeast","Account Manager","39500"
"01/06","Larry Jones","Northeast","Sr. Account Manager","84900"
"01/06","Stephan Lauzon","Northeast","Sr. Account Manager","124300"
"01/06","Sally Levitt","Northeast","Account Manager","37900"
"01/06","Lyle Perry","Northeast","Account Manager","0"
"01/06","Justine Pollock","Northeast","Account Manager","39000"
"01/06","Kerry Turner","Northeast","Account Manager","59300"
"01/06","George Washington","Northeast","Account Representative","7200
[...]
|
