We are in the process to determine if we should purchase Crystal Reports and have installed the trial version .
One of the things were are looking for is if there is a way to create a Crystal Report that functions like an Excel Pivot Table
Currently our users are using an excel Pivot Table updated weekly to analyze sales information. We are looking to give them a report generated nightly that could be accessed via our portal.
Any help would be greatly appreciated, Thanks!!!