Top "Pivot-table" questions

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

How do you create a "reverse pivot" in Google Sheets?

I am trying to produce a "reverse pivot" function. I have searched long and hard for such a function, but …

google-apps-script google-sheets pivot-table unpivot
Refresh Pivot Table with Apache POI

I'm currently working on a Java application that uses a template excel file that contains a pivot table. The template …

java apache excel pivot-table apache-poi
Custom Formula for Grand Total column

I have a frequent problem where the formula I want to use in the Values area in my Pivot-Table is …

excel excel-2010 pivot-table powerpivot
Filtering pivot table data with Laravel models

Let's say I have three tables (this is just an example): users user_id username roles role_id name user_…

php laravel filtering eloquent pivot-table
ASP.NET - Ideal Control to Display a Pivot Table

I am trying to display a tabular set of data in a databound control, but I need to pivot the …

asp.net listview pivot-table databound-controls
Excel VBA: PivotCaches.Create Type Mismatch

I used to work with vb a long time back (as part of the visual studio pkg) back in the …

excel excel-2007 pivot-table type-mismatch vba
Excel: Pivot Table - Percentage of one value from another

My pivot table has 3 columns: Row label (expand/collapse items in each row) Count of Case Count of Assigned My …

excel pivot-table calculated-field
Pivot table subtotals in Pandas

I have the following data: Employee Account Currency Amount Location Test 2 Basic USD 3000 Airport Test 2 Net USD 2000 Airport Test 1 Basic …

python pandas pivot-table subtotal
Calculating Percent of Total in Power Pivot Model

I have created a power pivot table as shown in the picture. I want to calculate quarter over quarter sales …

excel excel-formula pivot-table powerpivot dax
Google spreadsheets: Insert pivot table in the active sheet.

My question is pretty much stated in the title. I have been trying to add a pivot table in the …

google-sheets pivot-table