Top "Pivot-table" questions

A "pivot table" is a method of summarizing data in tabular form.

Excel pivot table - average of calculated sums

I'm sure this is simple, but how do I get a pivot table to display an average for a calculated …

excel pivot-table
how to pivot/unpivot (cast/melt) data frame?

How can I 'unpivot' a table? What is the proper technical term for this? UPDATE: The term is called melt …

r pivot-table reshape reshape2
Mysql query to dynamically convert rows to columns on the basis of two columns

I have followed a question here to use a Mysql query to dynamically convert rows to columns. This works fine, …

mysql sql pivot pivot-table
Dynamic Pivot Columns in SQL Server

I have a table named Property with following columns in SQL Server: Id Name there are some property in this …

sql sql-server tsql pivot pivot-table
How to get min value in a group?

Example: ID Value MAX Group1 2 6 Group1 4 6 Group1 6 6 Group2 1 3 Group2 3 3 Group3 7 8 Group3 4 8 Group3 2 8 Group3 8 8 Group4 1 3 Group4 2 3 Group4 3 3 Group5 7 7 The column 'MAX' …

excel excel-formula pivot-table array-formulas vba
How do I Use Pivot Tables to Create One Line Per Sub Category

Forgive me if this is not the "the best" place to ask excel questions. I looked at the data analysis …

excel charts analysis pivot-table
Flatten DataFrame with multi-index columns

I'd like to convert a Pandas DataFrame that is derived from a pivot table into a row representation as shown …

python pandas pivot-table
Pivoting a Pandas Dataframe containing strings - 'No numeric types to aggregate' error

There is a good number of questions about this error, but after looking around I'm still not able to find/…

python pandas pivot-table
pandas pivot table rename columns

How to rename columns with multiple levels after pandas pivot operation? Here's some code to generate test data: import pandas …

python pandas pivot pivot-table data-mining
Prevent Excel from refreshing Pivot Table until told to do so by VBA

I have an Excel Template (.xlt) that contains a Worksheet for report data, and 4x Worksheets with Pivot Tables. When …

excel pivot-table excel-template vba