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

trend analysis and conditional formatting with Excel Pivot Table

I am trying to apply conditional formatting to my pivot table, but can't seem to get it right despite a lot of research. Let's say there is the following raw data range/table describing how much different sales agents have sold per year broken down…
monohusche
  • 117
  • 2
  • 8
2
votes
1 answer

Design API for Create Pivot in Excel Using Java

I am Java Developer and I want to design Java API for creating a Pivot Table in Excel. However, I am stuck how would I create one? Does anybody have an idea about how to design Java API for creating a Pivot Table in Excel. I am familiar with POI,…
Ashu-Goel
  • 31
  • 1
  • 6
2
votes
1 answer

Excel: Is there a formula to reference a row of pivot table?

I've been working with Excel for many years and I have never come up with a solution to this problem. I have a pivot table which is performing all of my basic summaries. The data is divided into "Items" along the row fields and "Weeks" along the…
Matthew Crews
  • 4,105
  • 7
  • 33
  • 57
2
votes
1 answer

Filter-out odd numbers in a PivotTable

In the source sheet of my pivot table; contains two columns; one for the names and another for the scores. As the thread title suggests, I want to display all names and their corresponding scores of those with even number scores. An alternative way…
user1737389
  • 53
  • 6
2
votes
3 answers

Excel PivotTable Conditional Formatting

I have a pivot table in an Excel worksheet that contains the result of a query made to my database. I would like to format the information automatically based on every other data set. The information contains 4 weeks' (1 month) worth of records for…
designspeaks
  • 203
  • 2
  • 11
  • 22
2
votes
3 answers

Count parts of total value as columns per row (pivot table)

I'm stuck with a seemingly easy query, but couldn't manage to get it working the last hours. I have a table files that holds file names and some values like records in this file, DATE of creation (create_date), DATE of processing (processing_date)…
devrys
  • 1,571
  • 3
  • 27
  • 43
2
votes
1 answer

Creating a PivotChart in Access that replaces Null Values with 0

I have written a query in Access which I want to display as a PivotChart (Line Type). The query has the following fields:- ProductDescription (Column Header), MonthName (Row Header), GoodsSold (Data). The ProductDescription Field pulls its data from…
Jason Brown
  • 43
  • 7
2
votes
1 answer

How to organize structured data in pandas dataframe

Suppose I have a DataFrame which has a subindex structure like the following, with 'date', 'tenor' 'mat' and 'strike' and where the fields to be observed are stored in the column 'vol': date tenor mat strike vol …
mspadaccino
  • 382
  • 2
  • 5
  • 17
2
votes
1 answer

Moving date period filter in Excel 2010 pivot-table

Is it possible to set some kind of filter for a moving date period? For example one of the DB views I'm trying to replicate in my pivot-table has this filter : DATEDIFF(day, dateColumn, GETDATE()) <= 90 So basically I always want to display the…
hermann
  • 6,237
  • 11
  • 46
  • 66
2
votes
3 answers

Is it possible to use xslt to style a crosstab view?

I have an xml document that looks something like this: I want to create a crosstab view of this data in html with each row represented by a year,…
Price Jones
  • 1,948
  • 1
  • 24
  • 40
2
votes
1 answer

Need help using vba to fill in blanks left by excel pivot table when using %difference from previous row

So, I'm not very knowledgeable at all yet when it comes to VBA. I have experience with Java, so I understand the concepts of structure behind coding and can read/understand basic-intermediate code. But when it comes to writing it myself, I'm…
dootcher
  • 3,059
  • 4
  • 22
  • 18
2
votes
1 answer

"Pivot" a table in Excel

I've got a large set of data in Excel 2007, but the rows should have been columns, and vice-versa. Is there a simply way to "pivot" this spreadsheet, rearranging all cells so that the rows become the columns?
Robin Rodricks
  • 110,798
  • 141
  • 398
  • 607
2
votes
1 answer

Merging two columns for excel pivot report

I have data in my excel sheet that looks like the follows: For the sake of explanation I have hidden some columns (Please ignore them). I have taken pivot of the view you see above and the output of that is as follows: However, I am expecting an…
deostroll
  • 11,661
  • 21
  • 90
  • 161
2
votes
1 answer

Simple Pivot sample

I need the a report of all masterid's but it may only be one on a row.. I know that's a simple thing to do but I can't figure out the syntax correctly. I attached the data how its stored in SQL server and the output how I want it to…
Ezi
  • 2,212
  • 8
  • 33
  • 60
2
votes
1 answer

Python pandas to partially collapse 2d matrix

I would like to partially "collapse" a DataFrame/matrix and keep the structure intact by just summing the condensed values. For example, I have this: CHROM POS GENE DESC JOE FRED BILLY SUSAN TONY 10 1442 …
alexhli
  • 399
  • 2
  • 6
  • 20
1 2 3
…
99 100