Source
Dashboards, charts & interactivity — found from sitemap — ThoughtSpot
Checked for ThoughtSpot on 17 Nov 2026
- Page
- https://docs.thoughtspot.com/cloud/26.11.0.cl/chart-pivot-table.html
- Checked
- 17 Nov 2026, 11:24 UTC
- How we may use it
- Public page, crawling permitted
Technical details
- type
- page
- http status
- 200
- content hash
- sha256:1c23541fbcbf9b24238cf9540edc7fef4972b61d2ceefef2ff058172611b4fed
- permission
- robots_ok
- screenshot
- Screenshot on file (internal exhibit, not published)
Cited by
Facts read from this source
-
Pivot table definition Report an error
“Pivot tables enable you to explore an alternate visualization of your data in a wide, customizable table. They allow you to visualize some of your data horizontally and some data vertically in the same table. A pivot table is a chart time table that uses a drag-and-drop interface.”
-
Pivot table requirements Report an error
“You need at least one attribute and one measure in your search.”
-
Pivot contextual menu Report an error
“If you right-click a row or column heading, the system displays a contextual menu, allowing you to exclude or include values, drill down, show underlying data, SpotIQ analyze, or sort.”
-
Attributes in cells Report an error
“You can now include attributes in the pivot table cells as well as measures. This is useful for cases when you want to summarize text data such as user role, pass/fail, or other attributes. Note that when you add attributes to your pivot table cells, you will no longer see subtotals or grand totals below your pivot table.”
-
Measure grouping Report an error
“To compare multiple measures in a single view you can now group measures to share an axis. Grouping measures using Values allows you to control multiple measures in pivot table charts. You can move grouped measures and position them where you want in rows and columns.”
-
Grouped measures totals Report an error
“When measures are grouped using Values, all subtotals and grand totals are turned off by default. Individual subtotals and grand totals can be turned on in settings.”
-
Attributes in values unsupported Report an error
“Adding attribute fields to Values is not supported.”
-
New pivot features Report an error
“Performance Faster interaction while expanding rows and columns Pagination Customization Custom sort order support Column widths Slicing with measures and attributes Measure names and values UX Tooltips Legends Zebra mode Decluttered header space”
-
New pivot data limits Report an error
“But now this limit increases to up to 100,000 rows per measure. A pivot table with 3 measures — Sales, Profit, and Units Sold — broken down by Region and Product Category can now process up to 100,000 rows, three times the data it could handle before, with no changes to your analysis.”
-
New pivot visual units Report an error
“New pivot tables can render approximately 15,000–20,000 visual units at one time to maintain browser performance. A visual unit represents each unique row-and-column combination, calculated by multiplying the cardinality (number of unique values) across all row and column fields, excluding the innermost field on each axis.”
-
New pivot settings enabled via support Report an error
“Contact ThoughtSpot support to enable these settings for the new pivot tables on your ThoughtSpot instance .”
-
New pivot limitations Report an error
“Total size limit for a pivot table is 100,000/the number of measures in the pivot table.”
-
Top bottom keyword limitation Report an error
“If the query the pivot table is based on contains the top or bottom keyword, column and row summaries are not accurate.”
-
Heatmap conditional formatting limitation Report an error
“You cannot add conditional formatting to a pivot table in heatmap mode.”
-
Conditional formatting visualized only Report an error
“In new pivot tables, conditional formatting can only reference columns that are actively visualized (present in the Rows, Columns, or Values sections of the pivot). Columns moved to the Not Visualized section are excluded from the pivot’s data model instance and therefore cannot be used as conditions.”
-
New pivot function limitations Report an error
“You cannot filter aggregated columns or columns with aggregated formulas. Pivot tables do not support cumulative functions. Pivot tables do not support moving functions. Passthrough functions are not supported. Version control is not supported for Answers which use the new pivot table. New pivot tables do not support compact headers.”
-
Liveboard xlsx export Report an error
“You can export pivot tables in XLSX format. This feature ensures that pivot tables retain their full visual formatting and structural integrity when exported as XLSX files from a Liveboard. Previously, they would be exported as raw data table.”
-
Liveboard xlsx export requirements Report an error
“This is only available when the Enable XLSX & CSV exports in Liveboard Report API or XLSX/CSV download of Liveboards Include any visualization in XLSX/CSV schedules features are enabled. This feature is only supported for new pivot tables and not available for legacy pivot tables.”
-
Pivot reordering Report an error
“You can restructure your pivot table by dragging and dropping the measures and attributes under edit chart configuration , or by dragging and dropping column and row headings on the table itself.”
-
Measures in rows Report an error
“By default, ThoughtSpot displays measures in columns. To display measures in rows instead, follow these steps:”
-
Pivot sorting Report an error
“To sort any column or row, right-click a row or column heading or subheading or a measure or attribute name and select Sort. You can also sort from the search bar. Type sort by <column name> [ascending | descending].”
-
Multi attribute sort Report an error
“You can sort on more than one attribute at a time, as long as it works within ThoughtSpot’s logic.”
-
Measure sort rows only Report an error
“When you sort by a measure, you sort rows only.”
-
Sort persistence Report an error
“When you save a pivot table that you sorted, all sorting saves as well.”
-
Expansion retained in liveboard Report an error
“When you pin a pivot table to a Liveboard, it retains your expansion settings.”
-
Percent of total Report an error
“You can see your data as a percent of a row or column total, or as a percent of the grand total.”
-
Pivot summaries Report an error
“You can now choose whether to display column and row summaries, and where in the pivot table they appear.”
-
Summary calculation Report an error
“By default, pivot table summaries are calculated as separate SQL queries. The pivot total is the aggregate as defined for the column.”
-
Summary filter aware Report an error
“ThoughtSpot pivot table summary calculation changes now reflect any changes to the table data caused by filters or joins in the summary queries.”
-
Compact row headers Report an error
“You can view your row headers in a more compact (tree) layout. To turn on compact row headers, select Compact row headers in the Settings menu.”
-
Heatmap mode Report an error
“The heatmap functionality allows you to see which measures contribute more to the total than others within the table.”
-
Number conditional formatting Report an error
“You can perform conditional and number formatting on pivot tables. Both these features work the same way they work for regular ThoughtSpot tables, except that you cannot set different conditional formatting rules for pivot table cells and pivot table column summaries.”
-
New pivot conditional formatting scope Report an error
“You can format a column based on any other visualized column’s values — more flexibility.”
-
Blended axes Report an error
“With blended axes, you can group measures and control them through a system-defined chip called Values in the chart configuration settings.”
-
Values chip default position Report an error
“For the Pivot Table (Classic), the Values chip can be moved around, but its default position is in the Not visualized. section. For Pivot Table New, the default position of Values chip is in the Columns section for multiple measures.”
-
Pivot row limit Report an error
“The pivot table displays a maximum of 100k rows. If your query returns more than 100k rows, you cannot visualize it with a pivot table.”
-
Formula total limitations Report an error
“Subtotals and grand totals can be erroneous when one of the measures is a formula with aggregation. Subtotals can be missing when categorizing by a formula.”
-
Horizontal scroll headers Report an error
“If your pivot table contains multiple values with long names, the column header has a horizontal scroll bar, so you can see all your measures without taking up excessive space in the pivot table.”
Scores citing this record
- The Data Analyst Dashboards, charts & interactivity
- The Data Analyst Sharing, scheduled reports & embedding
- The Finance Controller Dashboards, charts & interactivity
- The Finance Controller Self-service analysis & shared metrics
- The Finance Controller Sharing, scheduled reports & embedding
- The IT Administrator Dashboards, charts & interactivity
- The IT Administrator Sharing, scheduled reports & embedding
- The Managing Director Dashboards, charts & interactivity
- The Managing Director Sharing, scheduled reports & embedding
- The SaaS Product Lead Dashboards, charts & interactivity
- The SaaS Product Lead Sharing, scheduled reports & embedding
- The Skeptic Dashboards, charts & interactivity
- The Skeptic Sharing, scheduled reports & embedding