Note:
If you use a pivot table as the data source, note that pivot tables are created in the Analyzer, discussed in Using the Analyzer. The Analyzer provides options for changing the state of the pivot table: filtering, drilling down, displaying listings, and displaying in chart format. When you save a pivot table, the system saves the state as part of the pivot table definition. The next time the pivot table is accessed (either in the Analyzer or in a widget on a dashboard), the system displays the pivot table in that state.