Summary pivot table report

A manager wants a  rollup (totals) of work items by type, status and priority to display as a dashboard widget.

We have been able to get the raw data into a excel spreadsheet and create a pivot table to get the totals.  We used JRS and exported the report after editing the sql to get the required data.

Is there a simple method to get this pivot table back into JAZZ on a dashboard?  or do we need to go the RPE route for this?