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

GETPIVOTDATA formula to return the total of a item within a given month

In my pivot table. I have my data setout like this.. M1 M2 M3 Country Item Australia Item 1 5 3 3 Item 2 3 6 7 Item 3 4 6 6 Australia Total 12 …
Keva161
  • 2,623
  • 9
  • 44
  • 68
2
votes
2 answers

How to make =GETPIVOTDATA more dynamic?

I have a pivot table with some data that im trying to reference with one sheet and then cross reference it with another to compare the two values. What I have at the moment is similar tot he formula listed here -…
Keva161
  • 2,623
  • 9
  • 44
  • 68
2
votes
1 answer

Pivot table with rollup and case statement in the Grouping function

I am trying to make a pivot table with rollup and a case statement in the grouping function.When the data in the column section of the pivot does not need to be altered my query works great, his is an example. http://sqlfiddle.com/#!3/3143e/2 But…
user973671
  • 1,620
  • 6
  • 27
  • 39
2
votes
2 answers

Generate Excel 2010 Pivot Table from Java

Does anyone know sever side library (free or not - it doesn't matter) which can generate pivot tables in excel 2010 format. POI can't do it. Now I'm evaluating SmartXLS but it uses Excel 2007 format. I need couple feature from Excel 2010 - like…
Max Grigoriev
  • 1,021
  • 2
  • 13
  • 29
2
votes
1 answer

Stored Procedure create Pivot Table using a Temp Table

I have a table Survey_Data_Response that is populated with an 'insert into' statement from two tables - Survey_Question and Survey_Response, they are joined on the QuestionID. I want to use a SP to pivot the Survey_Data_Response table and save the…
Stan
  • 595
  • 3
  • 9
  • 20
1
vote
1 answer

Problems selecting PivotItems in vba

I have the following code that loops trough a range and formats some PivotItems, according to the value of the range. The code jumps from one sheet (with the students name and answers) to the other (with the pivot table with two RowLabels,…
Pragabhava
  • 458
  • 6
  • 17
1
vote
2 answers

Using "Show values as" option in Excel 2007 pivot table when source is SSAS cube?

I have an Excel 2007 pivot table showing "Year" across the top and "Month" down the side. What I am trying to do is represent the values as "% Difference" from the same month of the previous year. (Ex. If Jan-07 is $100,000 and Jan-08 is…
Brad
1
vote
1 answer

Embedding an Excel pivot table into C# winforms

Does anyone know how I can embed an Excel Pivot table control in a win form application developed in C#? The raw data for the form would be coming from a SQL Server 2000 database and loaded into a DataTable. Thanks,
theburningmonk
  • 15,701
  • 14
  • 61
  • 104
1
vote
0 answers

Creating Dynamic Pivots with Grouping on the Fly

I would like to create a pivot as shown here: http://www.java2s.com/Code/Flex/Grid/HierarchicalAdvancedDataGridColumnGrouping.htm How ever I want to be able to do this dynamically. The usage in the project is to be able to represent any data from a…
Craig Mc
  • 505
  • 1
  • 13
  • 30
1
vote
0 answers

Create PivotTable from a XML File in Excel

Is there any way to do this? The structure my file has is something like the one below, but the file is large (around 5000 records in an 8MB xml file) and it has at least has one parent with many children that can vary from entry to entry (meaning…
edgarator
  • 296
  • 1
  • 4
  • 17
1
vote
1 answer

How to embed pivot table in java web application using eclipse BIRT

I have few questions regarding the pivot table functionality of BIRT 1) My first requirement is i want to embed the pivot table in my application so that end user can create the pivot table. it must provide drag and drop support. 2)Pivot table…
n92
  • 7,424
  • 27
  • 93
  • 129
1
vote
3 answers

Joined results as column names

I have this Mysql scenario table1 -------------- id `7` `8` -------------- 1 10 20 2 20 30 table 2 --------------- id code rel --------------- 3 7 1 4 8 2 I am using following statement to get values SELECT…
egidiocs
  • 2,747
  • 3
  • 21
  • 20
1
vote
1 answer

SQL Server query : rows make columns (Pivot?)

I hava a problme to make a query. This query which I created WITH TATH(Priority, EntryDate) AS ( SELECT TH.Priority as Priority, DATEADD(dd, 0, DATEDIFF(dd, 0, entryDate)) as EntryDate FROM TicketAssignment TA, TicketHeader TH …
Stonpid
  • 349
  • 1
  • 3
  • 14
1
vote
1 answer

Generate a column indicating year and quarter

I have a column with dates for financial transactions. I'd like to group them by quarter for a pivot table report. Not quite sure how to do this.
bradgonesurfing
  • 30,949
  • 17
  • 114
  • 217
1
vote
1 answer

Help needed with Dynamic Pivoting in SQL2005

I have a table of name value pairs where I am storing tags: TAGID | NAME | VALUE I have a table of 'Things' this tags apply to THINGID | TAGID I need a query to generate a resultSet were the columns/fields are all possible TAG-NAMES (NAME field in…
JohnIdol
  • 48,899
  • 61
  • 158
  • 242
1 2 3
…
99 100