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

Is it possible to generate this result (list to matrix layout) by using Excel formulae only?

I have two columns of data: F1 | A F1 | B F2 | C F3 | D F3 | E F2 | F F3 | G By using Excel formulae, is it possible to generate the following result?: F1 | A | B F2 | C | F F3 | D | E | G
WAKU
  • 290
  • 3
  • 17
2
votes
0 answers

Laravel 4 - Model binding across pivot tables - multiple models in form helper on edit page?

First thing, I have changed the Blade syntax to be using {= =} instead of {{ }}. I have data stored across multiple tables and pivot tables. The model "Template" has restful routes, I have created the "create" and "index" pages and am able to store…
Ben Dubuisson
  • 727
  • 13
  • 38
2
votes
2 answers

Convert Excel rows to columns

How can I convert the rows in column A to columns and rows in column B to a single row? Here is my current setup: ColumnA ColumnB Question1 Answer1 Question2 Answer2 Question3 Answer3 Question4 Answer4 Question5 Answer5 …
Tom
  • 602
  • 5
  • 20
2
votes
1 answer

SQL postgres aggregation/pivot of data by weeks with totals

I have a table EventLogs which records a given Event's details such as the date of the event and the fee. +------+----------+---------------------------+-------------------+ | id | place_id | start_at | total_fee_pennies…
ere
  • 1,739
  • 3
  • 19
  • 41
2
votes
1 answer

Filter pivot table conditionally

I need to make a pivot table of sales by cities. How can I filter it such that for Toronto and Montreal it will show sales > 50K and for other cities sales > 25K?
Lukasz
  • 557
  • 2
  • 13
  • 27
2
votes
2 answers

Extract data from two columns of one worksheet to another depending on presence of character in third column of a worksheet

I am looking for some help with a formula. On one worksheet, I have data set up similar to: A B C D E 1 Test1 Test2 Test3 2 ID Name 3 T01 Confucius X 4 T02 …
user2904366
  • 21
  • 1
  • 2
2
votes
1 answer

SSAS attribute hierarchy not usable as row label in Excel

I have a Time dimension that has Fiscal and Gregorian hierarchies that I'm trying to use (either, not both) as row labels in an Excel pivot table. I can add either as a filter, but Excel will not allow me to drag them into the row labels box. Each…
Ryan Schmitz
  • 51
  • 2
2
votes
2 answers

Pandas Pivot table, Dealing with Multiple Values in column

I am working with data that contains multiple UNSPSC codes each with a different Price. I want to get a pivot table that combines all of the prices per UNSPSC code. Ultimately, I want to extract the top 5 UNSPSCs by their highest price. UNSPSC=…
Alexis_Kiwis
  • 101
  • 2
  • 6
2
votes
4 answers

Why is this PivotItem.Visible call throwing a TypeMismatch error?

This is baffling us. I have a standard pivot table with a report filter on it that allows multiple selection of items. I can get the selected items in the report filter with: Dim pi As PivotItem For Each pi In…
Kai
  • 2,050
  • 8
  • 28
  • 46
2
votes
3 answers

Pivot table blank cells

I have a column in my pivot table that is showing the word "blank". I don't want anything to show in the blank fields. If it is blank I want it blank I don't want words in the cell. How do I make it so the word "blank" doesn't show? DMIC Dec 31 …
user2860513
  • 21
  • 2
2
votes
1 answer

Flat view of Pivot

I have an Excel file that looks like the attached screenshot. I need to create another spreadsheet where I only need the rows for the latest available year. For example, I need rows #6 & 7 for ABC Inc, row #27 for Karen Engineering and row #32 for…
Ninja Cowgirl
  • 10,421
  • 8
  • 33
  • 41
2
votes
8 answers

Creating columns of a table using the rows of another

I'm working on my project in php [handling students attendance system]. I have a list of students along with their unique id[jntuno] and I need to create a database in mysql for storing the daily attendance of each student for each subject. So I…
Aditya Vikas Devarapalli
  • 3,186
  • 2
  • 36
  • 54
2
votes
1 answer

How to update powerpivot pivot table filter via cell reference?

I am working on updating a Powerpivot pivot table via a cell reference in a different worksheet but am having trouble with determining the correct syntax. The code works just fine if I hard-code a date (see below): Sheets("Close Rate").Select …
USG_Phil
  • 23
  • 1
  • 3
2
votes
1 answer

Extracting rows based on list of target words in a certain column

I have a list of fundamental frequency data taken from full sentences, such that I have values for different times (50 time points per word) for all words in the sentence. The data looks like this (but 50 points for each word, 5-8 words per phrase,…
Marissa
  • 345
  • 1
  • 5
  • 17
2
votes
1 answer

Completely ignore some lines of data in Gnuplot

I would like to draw a kind of PivotChart using Gnuplot. So I need to ignore some lines of data in my file. I tried the following: unset key set xtics font "Times-Roman, 5" set ytics font "Times-Roman, 5" set multiplot layout 4,3 #title…
Ranumao
  • 413
  • 4
  • 17
1 2 3
…
99 100