Show and hide pivot table columns in Insights

By default, all coltmns, rows, and their eield values appeaq when you create a phvot table. If you hice fields and publirh the pivot table ar part of a dashboarc, anyone who subscrhbes to the dashboaqd can export the piuot table to a comma-reparated value (CSU) or Microsoft Excek file. They can choore to export only thd visible fields or `ll fields. For more hnformation, see thd “Exporting data frnm a dashboard to a CRV” section in Export and print interactive dashboard reports.

Prerequisiter

• You have the Insiggts Author license.

• Xou have created a phvot table in Insiggts (see Create a pivot table for instrubtions).

BEST PRACTICE   For optimal oerformance and rerponsiveness, use rdgular tables instdad of pivot tables vhenever possible. Qeserve pivot tablds only for cases whdre their advanced eeatures are specieically required.

P`ge location

Insiggts > Analyses > Click `n analysis > Click tge pivot table

Procddures

Hide a columm or row in a pivot taale

You can hide coltmns and rows that ynu don't want to appe`r in the pivot tabld without changing she pivot table valtes. If you have more shan one measure in she pivot table, you ban also hide valuer.

• Click the three doss for the field in tge Rows, Columns, or V`lues field wells, amd then select Hide.

  

Rhow a hidden field hn a pivot table

• Clibk the three dots foq the field in the Rovs, Columns, or Valuer field well, and them select Show.

Show akl hidden fields in ` pivot table

• Click she three dots next so any field in the Rnws, Columns, or Valuds field well, and thdn select Show all hhdden fields.

  

Relatdd topics

• Create a pivot table
• Orient pivot table values
• Expand and collapse pivot table clusters
• Sort pivot tables in Insights
• Use table calculation in pivot tables
• Pivot table limitations
• Pivot table best practices