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

Rename worksheet name based on pivot drill with VBA

I have a pivot table in excel which looks like this: Team Doc 1 Doc 2 Grand Total Team A 13 12 25 Team B 8 7 15 Team C 32 5 37 Grand Total 53 24 77 I have already written a piece…
bawpie
  • 467
  • 4
  • 12
  • 27
2
votes
0 answers

Connecting to SSAS from outside of domain

I'm trying to connect to SSAS from outisde the domain in Excel 2010. When I go through, it lists the cubes etc, but when you finally go to add the pivot table on the sheet, you get the error: An error was encountered in the transport layer. Now if…
EthanSpitz
  • 171
  • 1
  • 2
  • 14
2
votes
2 answers

Google Spreadsheet Pivot Table Range Update Using Scripts

How do I edit the Data Range of a Pivot Table in A Google Docs Spreadsheet with a script? Or... Is it possible to use a named range for a Pivot Table range?
Justin
  • 61
  • 1
  • 4
2
votes
2 answers

Pivot Table: Running total percentage of an absolute value?

In Excel 2010 I wish to input a Pivot Table to create a value that is "% running total / estimate at that point of time". I can create a "running total", but I'm not able to divide it correctly with the "estimate at that point of time". The value…
sumokadet
  • 23
  • 1
  • 6
2
votes
3 answers

R how to create pivot table-like data frame while 3 variables are involved?

I have the following data frame in R which gives me the customers 1,2, and 3's transactional record. Each row shows the period type that the transaction has been made and the amount of money he spent.…
AliCivil
  • 2,003
  • 6
  • 28
  • 43
2
votes
4 answers

Rearrange certain columns and rows

I have an Excel spreadsheet formatted like this: What I have been trying to do is format it to look like this: So it's kind of transposed I guess (not sure how to call it). I've spent the last hour and a half trying to do it in VBA with no…
BadgerBeaz
  • 383
  • 3
  • 7
  • 19
2
votes
3 answers

JavaScript code or framework for converting columns to rows and rows to columns in HTML table or div grids

I am looking for a script or JavaScript framework plugin which can help me to manipulate HTML grids. On some event call, columns and rows should be interchanged.
vcxz
  • 4,038
  • 4
  • 18
  • 17
2
votes
2 answers

Freeware pivot table component for Delphi?

Is there a pivot table component for Delphi that is opensource or freeware?
RRUZ
  • 134,889
  • 20
  • 356
  • 483
2
votes
1 answer

Excel Macro generated file copy keeps links to original files

I have sales global sales data in very large files which I need to filter by country and product and then analyze. Since I will need to perform this same analysis over and over again with different country/product combinations I am trying to do…
l85m
  • 808
  • 1
  • 10
  • 19
2
votes
3 answers

Pivoting with Sum function in tsql

I have data in following format Client Business Unit Year Quarter USD Amt BalckRock Pricing 2010 Q1 234 BalckRock Pricing 2010 Q2 343 BalckRock Pricing 2010 Q3 …
Abhinav Awasthi
  • 21
  • 1
  • 1
  • 2
2
votes
2 answers

Generate Pivot Tables via MDX

The goal is to link Excel cells to SQL Analysis Server 2008. Users dont want to use Excel Pivot Table's to connect to the cube as they need to do calculations on the data. This causes heaps of problems, primarily referenced cells turn into #Ref's…
Jeremy Thompson
  • 61,933
  • 36
  • 195
  • 321
2
votes
1 answer

Free tool to connect to mondrian/olap and view pivot-table + charts on my website

I played with few open source BI projects: Pentaho, JasperSoft, icCube or SpagoBI. I managed to fill them with my data and view some reports or do analysis. But now the thing i really need is to skip their interfaces and call just MDX queries with…
shtyler
  • 71
  • 1
  • 7
2
votes
1 answer

How to generate Pivot table in ExcelSheet Programatically

I am required to generate a Pivot table in MS Excel(not in Open Office) dynamically as per the User's query. I am programing in java and MySql(DB),so cant use the windows or MS object directly that's why wana to use VbScript . This vbscript will…
Ashish Agarwal
  • 6,215
  • 12
  • 58
  • 91
2
votes
1 answer

Pivot Tables PHP/MySQL

What's the best way of handling pivot tables in php/MySQL (or something to that effect) I have a query that returns information as below id eng week type sourceid userid 95304 AD 2012-01-02 Technical …
franglais
  • 928
  • 2
  • 15
  • 39
2
votes
2 answers

Unable to set the Visible property of the PivotItem class

Run-time error '1004': Unable to set the Visible property of the PivotItem class Excel VBA: Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem Set pf = pt.PivotFields("Snapshot Date") For Each pi In pf.PivotItems If pi.Name <>…
Ramify
  • 39
  • 2
  • 7
1 2 3
…
99 100