Crystal Report that functions like an Excel Pivot Table

Hello,

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!!!