View - Activity
- Export of activity data to Pivot in Excel
You can assemble a list of all activities and paste them straight into a Pivot table.
Pivot tables may seem complicated, but once you have mastered the technique the possibilities for working with them are endless. You can put together any imaginable number of combinations of employees and activity types, which will provide you with the contexts you are looking for in your analysis.
You use a wizard to perform the export, and choose a limited period from which figures are retrieved.
The wizard for exporting to Pivot
Start the wizard from the View - Activity and Export of activity data to Pivot in Excel menu.
Enter the From date and To date to denote the period from which you want to get the data for.
Select setup
in the drop-down menu below.
This only determines the structure of the Pivot table when you open
the Excel file. The same data are exported for all the selections and
later can be combined as you wish later.
Click Next to produce the Excel file.
You can now continue to process the data
in the Pivot table, or include it in the calculations you require. Remember
to save the Excel sheet in a place where you can easily access it.
Read more about: