Pivot tables can be created from any entry form. The pivot table will be based on the data on the List tab of the form in question. Where required, you can add calculated data and customize the display.
Example
You would like to know the answer to the following question: What is the daily turnover in the UK and France? With some effort, you can derive this information from the List tab of the Turnover data form.
Invoice |
Country |
Customer |
Turnover (euro) |
Date |
100052 |
UK |
Petersen |
1053 |
05-05-2011 |
100053 |
UK |
Petersen |
1322 |
05-05-2011 |
100054 |
UK |
Dwight |
680 |
05-10-2011 |
100055 |
France |
Le Terme |
1198 |
05-10-2011 |
100056 |
France |
Limington |
1150 |
06-14-2011 |
100057 |
UK |
Petersen |
690 |
06-20-2011 |
100058 |
France |
Limington |
987 |
06-25-2011 |
Using a pivot table, you can quickly and easily find the information you want.
Turnover total (euro) |
Date |
|
|
|
|
|
Country |
05-05-2011 |
05-10-2011 |
06-14-2011 |
06-20-2011 |
06-25-2011 |
Grand Total |
France |
|
1198 |
1150 |
|
987 |
3335 |
UK |
2375 |
680 |
|
690 |
|
3745 |
Grand Total |
2375 |
1878 |
1150 |
690 |
987 |
7080 |
To find the answer to the following question "What is the monthly turnover in the UK and France?" you can have the monthly values added up and the total displayed.
Turnover total (euro) |
Month |
||
Country |
May |
June |
Grand Total |
France |
1198 |
2137 |
3335 |
UK |
3055 |
690 |
3745 |
Grand Total |
4253 |
2827 |
7080 |