The Izenda reports Pivot feature allows users to generate analytical data grids from within Izenda reports. The Pivot feature essentially adds extra pivot columns to the right side of the report. This is useful for comparing data over multiple categorical dimensions.
Below is an example of the Design and Output of a standard Pivot View of the Average Amount Spent on Freight.
Create pivot view on above report:
Essentially, the pivot capability adds additional columns based on the data to the right of the report. In this example, the first column is essentially a standard report and the 2010, 2011, 2012 columns were added by the pivot capability.
Standard Report View:
Columns added by Pivot:
Let's use these concepts to develop a more sophisticated report that shows us a monthly time-series report for each country visually grouped by employee.
In this report, we want to show the Top 5 companies that accounted for the most freight in 2011 and breakdown the analysis by month.
Here is what the design screen would look like for this report.
Here's how we add the non-pivot fields.
For the pivot portion of the report, we:
Finally, here are the results of the report with Pivot:
To make the report more consumable, you might also want to add highlighting to show the months with lows values.
For this, click on the Advanced Field Settings icon on the pivot field where you are calculating cell values on.
Then, set the Cell Highlight to 0 to 50: Red.
Here is the result:
Last edited by Joseph Adams, 2014-06-02 09:28:05