OptionalcategoryWhether to show buttons for the fields on the category axis.
OptionalexpandWhether to show the buttons that expand and collapse category levels.
OptionalfilterWhether to show buttons for the report filter fields.
OptionalhideWhether all field buttons are hidden. Overrides the individual settings below.
OptionalseriesWhether to show buttons for the fields that make up the series (the legend).
OptionalvalueWhether to show buttons for the value fields.
Field buttons on a pivot chart. Each button lets a user filter or sort by a pivot field directly on the chart.