This Pivot Table ('cube') is a kind of report that shows timesheet hours according to a number of 'dimensions' that you can specify. This cube effectively replaces a dozen of specific reports and allows you to 'drill down' into results.
Please take note about the display of the project hierarchy:
- 'Main Project' is the topmost project.
- 'Sub Project/Task' is the project or task below the main project. If the hours were logged on a main project, then the main project name will appear again.
- 'Leaf Project/Task' refers to the sub project or task at any level of depth where the hours have been logged.
Preview this LIVE on our public demo-server