The Pivot Gadget provides an advanced reporting tool which allows you to quickly visualize key information tool contained in your JIRA.
It provides similar functionality as found in the spreadsheet and business intelligence software. The two dimensional matrix on steroids

It is useful for quickly creating cross tabulations across a long list of dimensions and measurements. 

Here is a complex example of a pivot gadget tabulating fix version against issue type by epic