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

How to retrieve specific information from a column and show its number of occurrences

I have a column which contains dates. I want to search this column and find the total entries for each month, and summarize the sum in a nice display. Example: I want to display the number of times 'Disposition Verification Dates' occur in each…
noname738
  • 61
  • 6
2
votes
2 answers

SQL Pivot Table Dynamic causes error "The number of elements in the select list exceeds the maximum allowed number of 4096 elements."

I'm new to MS SQL Server PIVOT function and so far not so good I've no idea what I'm doing wrong... I've had a look at many other examples but everyone seem to have different requirements. I've a Vehicle and each Vehicle has different prices e.g.…
Morgs
  • 1,558
  • 3
  • 19
  • 34
2
votes
6 answers

Excel - calculating durations of time data spread across multiple rows

I have a spreadsheet with a dataset of a number of transactions, each of which is composed of substeps, each of which has the time that it occurred. There can be a variable number and order of steps. I'd like to find the duration of each…
Kris C
  • 2,828
  • 1
  • 29
  • 25
2
votes
1 answer

Disabling other slicers in excel when slicer is pressed

I have three slicers operating on a pivot table and pivot chart in excel. However, the filters placed from the two other slicers has to be cleared, when one of the slicers is pressed, assuring that only one slicer is operating at the same time. I…
bjornasm
  • 2,211
  • 7
  • 37
  • 62
2
votes
1 answer

How to sync additional fields in pivot table [Laravel 5]

I need to update my additional filed user_id in pivot table... I tried like this: $commet = Comment::find(2); $commet->likes()->sync([2,'user_id'=>1]); But my filed is updated with 0. Any solution for this?
Vladimir Djukic
  • 2,042
  • 7
  • 29
  • 60
2
votes
1 answer

Copy Filters from one PowerPivot PivotTable to another

I have 2 PivotTables that were created from PowerPivot connections. I would like the second PivotTable to change based on a selection the user makes on the first PivotTable. I have some VBA background, so you don't need to write the whole code but…
Jayesh Menon
  • 59
  • 1
  • 5
2
votes
1 answer

how to make pivot query in mysql?

I have a table criteria whose structure is like this: +----------+------+-------+ | criteria | user | total | +----------+------+-------+ | xxxxxxxx | xx | xxx | +----------+------+-------+ I have a problem to creating a query. I want make a…
user5332276
2
votes
0 answers

VBA conditional formatting of pivot table subtotals

I am still quite new to vba and have enjoyed it a lot, however I have been having a problem with formatting pivot tables. I want to highlight cells above or below a certain value and have come up with the following code by recording. Sheets("41 &…
Ross Thompson
  • 21
  • 1
2
votes
1 answer

Speeding up refresh time for multiple PivotTables using a single external OLAP cube

I have an Office Data Connection (ODC) pointed at an OLAP cube stored on our company's server. The connection string is fairly straightforward: Provider=MSOLAP.6;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Reporting…
vbevan
  • 93
  • 1
  • 9
2
votes
0 answers

How to read PivotTable with Apache POI?

I need read a Pivot Table from a sheet. This is the file and the sheet is Plan 01. This is the Pivot Table: How read this in Java?
crissilvaeng
  • 165
  • 1
  • 12
2
votes
1 answer

Replacing Pandas PivotTable Non-Null Result Cells With A Fixed String

I'm trying to convert a CSV that looks like the 1st example into one that looks like the 2nd example below. I've been playing with Pandas and think I have the fundamentals working, but I can't seem to figure out how to do one last transformation…
k..
  • 401
  • 3
  • 11
2
votes
1 answer

matlab rows to column labels

If I have data organized like this: a c 1 a d 2 b c 3 b d 4 I want to use a and b as my row identifiers and c and d as my column identifiers, yielding a table like this: c d a 1 2 b 3 4 I can accomplish this with a loop in the following…
siegel
  • 819
  • 2
  • 12
  • 24
2
votes
1 answer

Pivot_table MultiIndex to columns

I have the following table : In [303]: table.head() Out[303]: people weekday weekofyear 2012-01-01 119 6 52 2012-01-02 76 0 1 2012-01-03 95 1 1 2012-01-04 102 …
gowithefloww
  • 2,211
  • 2
  • 20
  • 31
2
votes
0 answers

Complex MySQL queries with multiple tables

1. Student Table 2. Subject Table 3. Exam Table 4. Mark Table 5. Project Table 6. Daily Mark Table Result Table Suppose i have subjectID and classID for search. Then below example result will be show using above database table : Exam could be…
Shìpu Ahamed
  • 430
  • 4
  • 16
2
votes
2 answers

SQL Server Flatten Data

I have 3 tables: tUsers -uid tColors -colorid -colorname tColors_User_Detail -uid_fk -colorid_fk Users select which colors they like, and only the colors they like. This creates records in tColors_User_Detail. I need to flatten this…
devnuts
  • 137
  • 2
  • 14
1 2 3
…
99 100