Say Goodbye to Excel
Pivot Tables are now available in SugarCRM with KReporter
KReporter Release 3.0.4 is upcoming and will also bring a set of new features for the Pivot Grid. A very nice form of report if you have highly dynamic data.
Below is a sample screenshot of how flexible this plugin is and demonstrates the potential of the Pivot table reporting:
Watch a Screencast on Youtube on the new capabilities including sums and totals as well as a fully integarted Excel Export that will produce excel exports with the Pivot data now as well.