Stack Overflow
Stack Overflow

Questions tagged [pivot-table]

A "pivot table" is a method of summarizing data in tabular form. Typically, these have a category column in the left hand side, and multiple summary columns to the right. Each different category will have its own row. Be sure to include the relevant language tag (python, excel, R, postgreSQL etc.) on your question.

A "pivot table" is a method of summarizing data in tabular form. Typically, these have a category column in the left hand side, and multiple summary columns to the right. Each different category will have its own row.

Pivot tables are typically found in data visualization programs, including spreadsheets and business intelligence. Note that a "pivot table" is also known as a "cross tab" or "cross tabulation".

Resources:

8105 questions
2
votes
1 answer

PostgreSQL 9.3: Filter in Pivot table query

Well I have this records: Employee_Number Employee_role Group_Name ---------------------------------------------------- EMP101 C# Developer Group_1 EMP102 ASP Developer Group_1 …
MAK
  • 6,824
  • 25
  • 74
  • 131
2
votes
1 answer

How to Pivot with Daily Averages based on Times in Excel?

This sheet contains a call log where there are a variable amount of calls per day, with a variable amount of call durations. My goal is to create a chart that shows the number of calls as each day passes, but also show the average call duration per…
Mark H
  • 38
  • 1
  • 1
  • 7
2
votes
0 answers

Excel 2010 Pivot Tables - Subtotal as an Average of Sums

I have a pivot table that takes a resources % utilisation each month for each project they are on, shows it as a SUM, and sumarises by what department they are in. This looks like: Jan-15 Feb-15 Department …
Daniel Phillips
  • 21
  • 2
2
votes
6 answers

Mysql sales table grouped by customer and displayed by month columns pivot query

I have a sales table with the following columns: | Customer_Id | amount | date | What would be the best way to group data by customer_id, and displaying monthly total(SUM) of amount for each Customer_id (one row per Customer_id), on distinct…
helloworld
  • 527
  • 6
  • 21
2
votes
3 answers

C# VSTO: Coloring pivottable cells

HI, I'm trying to make some code color a PivotTable. It works just fine coloring the cells it's supposed to, but if I refresh the table, all the colors disappear, as if the colors haven't been properly attached to the PivotTable. I have the…
user344858
  • 21
  • 1
  • 3
2
votes
1 answer

Get all records from Model that do NOT have an entry in pivot table Laravel 5

I am trying to figure out how to achieve the following. I have searched and searched to no avail. I have a pivot table in a Laravel 5 app that is working as expected with the following functions in the respective models. // Module.php //... public…
madmatuk
  • 117
  • 4
  • 12
2
votes
5 answers

How can I display the MDX generated by Excel 2007 when using a pivot table?

Pretty much what the title says. Is it possible to show the MDX that is sent to OLAP source when using a pivot table in Excel 2007?
Espo
  • 41,399
  • 21
  • 132
  • 159
2
votes
1 answer

How to display ratio members in a non-measure dimension (accounts) in Excel

Using the pivot table in Excel with an OLAP Server (icCube), I would like to add financial logic. The logic is not in the measures as I would like to apply the logic to multiple measures (e.g. amount, last_year_amount, budget etc). I would like to…
Arthur
  • 1,692
  • 10
  • 14
2
votes
1 answer

Dates In Separate Columns

Is it possible, using Excel (currently have access to 2007 in our office), to make the data in Table 1 appear as it does in Table 2 using PivotTables or some form of conditional formatting? TABLE 1 Mem Name Mem Num Appt Date …
zabarrie
  • 21
  • 3
2
votes
1 answer

AdventureWorks, Cubes and Prev.Member

I am working through the Adventure Works tutorial on the MSDN site and making good progress. I was trying to test myself and go off the guide to see if I was understanding the lessons and I've gotten myself a bit confused. My intention was to use…
user3581333
  • 21
  • 2
2
votes
1 answer

How can I iterate over Pandas pivot table? (A multi-index dataframe?)

I have a pivot table I want to iterate over, to store in a database. age weekly_income category_weekly_income category_age High income Middle aged 45.527721 15015.463667 …
Chris
  • 5,664
  • 6
  • 44
  • 55
2
votes
1 answer

Sum of average column in PivotTable

I have a data column of averages. I need to put in "total" column the sum of these averages. Average1: 200 Average2: 400 Total: 600 (not 300) Is it possible?
enfix
  • 6,680
  • 12
  • 55
  • 80
2
votes
1 answer

SQL Query conversion from Access to MySQL

I have an application that I wrote in JavaScript/HTML that utilizes a local machine database. It's a pretty complex problem but I just need help with the SQL query right now. More info on the local JavaScript database class is found here: JavaScript…
Crimpy
  • 195
  • 20
2
votes
1 answer

How to add Average to the Pivot table in Excel?

I have columns with count of Customers and count of orders. how can i show the average count of orders?
None
2
votes
0 answers

pandas pivot table with same rows and columns

I have a data frame. I would like to create a pivot table from this dataframe with both the rows and the columns of the pivot table equal to df['event']. In [7]: df Out[7]: event event_time num session_id 0 dog 1 2 a 1 cat 2 3 …
JoeDanger
  • 3,325
  • 4
  • 13
  • 14
1 2 3
…
99 100