Citra Pivot
Pivot tables allow you to create powerful business reports. Please see below for two demo applications.
Online Demo
The demos are published as Java Webstart applications. If you do not have a Webstart enabled browser, go here to update your browser.
Demo application showing one pivot table: link
Demo application giving users the ability to create multiple pivot tables: link
Description
The demo's data have been taken from the northwind database.
What to try in the demo:
- Drag and drop hierarchies between the 'sales' cube, the 'paging dimensions' and the pivot table areas.
- Expand a dimension in the 'sales' cube to see its hierarchies or measures.
- Expand/collapse a pivoted hierarchy's member.
- Click on a member to drill into the member.
- Click on a 'drilled' member's back icon to drill up to its parent.
- Click on a member's filter icon to select/deselect visible members.
- Drag and drop a hierarhcy onto the 'paging dimensions' area and double-click in order to create a slice of the data.
- Right-click inside the pivot table in order to bring up a popup menu, allowing you to perform certain OLAP functions. These functions are: show/hide empty cells, sorting, filtering, top/bottom, swap axes, visual totals, show/hide empty cells, grand totals and subtotals, move hierarchies between the row/column/paging area, hide, expand, collapse, drill up, drill down, drill through a member.