The following picture shows the architecture of pivot table.
The Filter Header Area displays the headers of all the visible filter fields.
The Data Header Area displays the headers of all the visible data fields. Data cells, total cells and grand total cells are displayed in the Data Area.
The Column Header Area displays the headers of all the visible column fields and the Data Field Anchor (if present). Column headers that correspond to the values of the column fields, subtotals and grand totals are displayed within the Column Area.
The Row Header Area displays the headers of all the visible row fields and the Data Field Anchor (if present). Row headers that correspond to the values of the row fields, subtotals and grand totals are displayed within the Row Area.
Filter fields allow you to apply a filter to the entire pivot table to display data for specific values. You can specify the filter criteria using the filter dropdown window which is invoked by clicking the filter button. To further filter the data displayed within the data area, you can apply filter criteria to the field values of column fields and row fields.
Data Cells are located in the data area of the pivot grid. Data cells display Cross Cells, Total Cells and Grand Total Cells. Cross cells display summary values which have been calculated for row and column fields.
A weekly/monthly time report on which projects/tasks you have worked, how many hours and the sum.
A monthly time report on which projects/tasks you have worked, how many hours, how much they cost and the sum.
To get this report,
drag the Week field to the Filter Header Area.
drag the Client Cost field to the Filter Header Area.
A weekly/monthly time report on which projects users have worked, how many hours, how much they cost and the sum.
To get this report,
drag the Task field from the Column Header Area to the Filter Header Area.
drag the User field from the Filter Header Area to the Column Header Area.
use the filter button of Project field to get the project you interested in.
A weekly/monthly time report on which projects users have worked, how many hours, how much they cost and the sum.
To get this report,
drag the Task field from the Column Header Area to the Filter Header Area.
drag the User field from the Filter Header Area to the Column Header Area.
use the filter button of Project field to get the project you interested in.
adjust the order of the User field and the Project field.
A weekly/monthly expense report on which projects/categories your money have been invested to, how much money spent and the sum.
A quarterly/monthly expense report on which projects/categories your money have been invested to, how much money spent and the sum.
To get this report,
drag the Quarter field from the Filter Header Area to the Row Header Area.
drag the Week field to the Filter Header Area.
to change the data to analyze, you can choose the Time Span of the expense entries, or specify the From and To field in toolbar.
you can click the + expend button to get more detailed information, or click the - minus button to get summary information.
Every field header has a filter button, just click it, then you can get a filter dropdown window, where you apply a filter to the entire pivot table to display data for specific values. The following report just shows expenses about three projects, and filter out one project's information.
Top
of Page
© 2002-2008 eTimeInc. All Rights Reserved.