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
3 answers

Summary table with row/column totals using SQL pivot

I need help with SQL for generating pivot table with row/column totals calculated ..I have 2 tables as given below Table ProbCat ============== probcat | probdesc 1 minor 2 high 3 showstopper Table…
Thirumala Kalluri
  • 23
  • 4
2
votes
0 answers

Add Mac Excel Shortcuts when command is in the ribbon but not the menu bar

I'd like to add keyboard shortcuts for Mac Excel commands that are normally accessed by clicking an icon in the ribbon. For example, I'd like a keyboard shortcut that opens the PivotTable Builder, which is used to modify an existing PivotTable.…
Owen Brown
  • 179
  • 9
2
votes
2 answers

How to get DISTINCT column and COUNT of column in MySQL?

I don't know how to write query for following problem. I am using following query SELECT * FROM ( SELECT cont_details.*, location.location, depot_details.depot_name as depot_name, …
Jonathan John
  • 195
  • 2
  • 4
  • 12
2
votes
2 answers

pandas pivot_table without grouping

What is the best way to use pandas.pivot_table to calculate aggregated functions over the whole table without providing the grouping? For example, if I want to calculate the sum of A,B,C into one table with a single row without grouping by any of…
Pan Yan
  • 1,622
  • 1
  • 18
  • 21
2
votes
1 answer

Pivot Tables in Pandas- Unorderable Types

I've got a pandas dataframe (df) that basically looks like the following TestDate Manager Score 0 2015-06-05 00:00:00 Jane Smith 5.000000 1 2015-06-05 00:00:00 John Doe 4.875000 2 2015-06-05 00:00:00 Jane Doe …
John
  • 1,405
  • 2
  • 14
  • 21
2
votes
1 answer

Pivot Table in MySQL not returning correctly

I know this question have been asked few times and I am trying to do exactly what the accepted answers are but obviously I am doing something wrong and can not get the desired output. I would like to return data in following format: Name | …
snowflakes74
  • 1,307
  • 1
  • 20
  • 43
2
votes
3 answers

Overwrite double click action in a PivotTable to go to filtered source data

I'm trying to create a PivotTable in which a double click on a value leads the user to the filtered source sheet with the rows that this value represents, rather than a new sheet with the underlying data. This is how far I've gotten, but I'm having…
MattV
  • 1,353
  • 18
  • 42
2
votes
2 answers

Pivot with ID and Dates

I have this data set and Im trying to create a pivot table for the data below. I having some issues when trying to put in the date for each type across. Member ID Type Date 1 A 12/5/2014 1 b 3/6/2014 2 …
Amaury
  • 37
  • 6
2
votes
1 answer

Pivot Table with multiple rows all having the same level hierarchy

I have imported a bunch of data using PowerQuery into a single table and am building dashboard reporting. I have been using Pivot Tables to build my reports, which has worked fine so far. However, I've come to a point though where I want to simply…
MarkO
  • 63
  • 2
  • 10
2
votes
2 answers

VBA - test if a value is a valid selection for a PivotField

For a pivot table (pt1) on Sheet1, I use VBA to change the value of a filter field (filterfield) using the code below. Let's say values for field can be A, B or C Sheets("Sheet1").PivotTables("pt1").PivotFields("filterfield").CurrentPage =…
rvictordelta
  • 630
  • 2
  • 8
  • 23
2
votes
3 answers

How to use PIVOT and JOIN together in SQL Server?

This is table 'VendorItemPricing'. ItemID VendorName VendorPrice 122 HP 215.13 122 IBM 264.41 122 Microsoft 257.65 I used this query to get make rows as columns. Select ItemID, [HP] As HPPrice…
good-to-know
  • 742
  • 3
  • 15
  • 32
2
votes
1 answer

What does the SSAS setting None in AggregateFunction do?

As I understand Microsoft's explanation setting the AggregateFunction of a measure to "None" should null out the value unless you are viewing the data at the lowest possible level. (i.e. the data element is a copy of the value in one exact cell in…
Scott Wood
  • 1,077
  • 3
  • 18
  • 34
2
votes
0 answers

Creating Pivot Table using poi java

I am creating pivot table in xlsx using poi and java.Here i have some questions,Please let me know if you guys know any solutions. My Code is below XSSFWorkbook wb = new XSSFWorkbook(); XSSFSheet sheet = (XSSFSheet) wb.createSheet(); …
Ramachandran Periyasamy
  • 69
  • 8
2
votes
2 answers

Date Sorting in Excel PivotTables

I have a PivotTable that has a date field in it, call it Mydate. I have put this as a column label and then grouped the label by Years, Months and Days. I then have put the years and days in reverse order by clicking on the label and then choosing…
OpiesDad
  • 3,385
  • 2
  • 16
  • 31
2
votes
0 answers

ABS(column) not working in Excel PivotTable Grand Total

I have a Pivot Table in Excel with a Calculated Field but the Grand Total in the Pivot table doesn't seem to work as you would expect. You would think that the Grand Total for Column Sum of abs value is the Total of the cells in the…
Alex
  • 909
  • 2
  • 11
  • 25
1 2 3
…
99 100