pivot table

[ˈpɪvət ˈteɪbəl]
nounpl: pivot tables
tabela dinâmica
1. A data summarization tool in spreadsheet software that automatically sorts, counts, totals, or averages data stored in a table or database, allowing users to reorganize and analyze data without modifying the original dataset
I created a pivot table to analyze sales by region and product category.
Criei uma tabela dinâmica para analisar vendas por região e categoria de produto.
2. A feature in applications like Microsoft Excel, Google Sheets, or LibreOffice that enables users to extract significant structure from large datasets
The pivot table quickly summarized millions of transaction records.
A tabela dinâmica resumiu rapidamente milhões de registros de transações.
Pivot tables are extensively used in Brazilian business environments, particularly in data analysis, financial reporting, and business intelligence. The term 'tabela dinâmica' is standardized in Microsoft Office Portuguese versions and is universally understood among professionals working with spreadsheets in Brazil and Portugal. The feature has become essential in corporate training and data literacy programs across Portuguese-speaking countries.
Synonyms / Sinônimos
data pivotpivot reportcross-tabulationOLAP cube

Regional Variations

General Brazilian
tabela dinâmica
Most common term used in Brazil for this Excel/spreadsheet feature
São Paulo
tabela dinâmica
Standard usage in business and corporate environments
Portugal
tabela dinâmica
Same terminology used; sometimes 'tabela de resumo' in older contexts
Technical/IT Portuguese
tabela de resumo or tabela resumida
Alternative technical terms, though 'tabela dinâmica' is predominant

Related Words

spreadsheetdata analysisfilteringsortingaggregationcrosstabdata summarization

Related Idioms & Phrases

drag and drop fields into a pivot table
refresh a pivot table
build a pivot table from scratch
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →