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

COUNTIFS including entire column rather than one single item

Goal: To run a COUNTIFS matching Sheet2!A:A to Sheet1!B:B and a completed status from sample below. The goal is for sheet 1 to have training information pulled from a database and then I need to calculate who from that database has completed a list…
Kelsie B
  • 23
  • 1
  • 1
  • 4
2
votes
2 answers

Updating pivot table by id in laravel

bookmaker table id name bookmaker_user table id account_name bookmaker_id user_id user table id name User Model : public function bookmakers(){ return $this->belongsToMany('Bookmaker', 'bookmaker_user', 'user_id', 'bookmaker_id') …
edofthadead
  • 47
  • 1
  • 7
2
votes
1 answer

CubeField? Setting filter values on pivot table

I have an excel file with several Macros. In this file there is a pivot table with a column called "Customer", which contains several elements (thousands). What i want to know is, is there any efficient way to set up the filter of this column to…
Fab
  • 49
  • 4
2
votes
2 answers

Excel VBA PivotTable ShowDetails

I have a pivot table that contains a number of Expand/Collapse buttons related to Customer, Year, and Quarters all of which have vba behind them to .Showdetails as appropriate. These individual sets of code work. However, I'm trying to make my code…
S8Tony
  • 85
  • 1
  • 1
  • 9
2
votes
1 answer

Efficiently displaying Top N in Excel PivotTable from SSAS Tabular Model

I have a simple tabular model consisting of a fact table with approx. 20 mio. records (sales transactions) and a dimension table with approx 600.000 records (customers). A typical reporting scenario is to get the top 10 customers over some measure…
Dan
  • 10,480
  • 23
  • 49
2
votes
3 answers

Excel Conditional Formatting expanding with pivot tables?

Once conditional formatting is applied to a pivot table, if you expand the table, how can the conditional formatting be updated automatically to apply itself to the new expanded pivot table? Attached is the sample excel file.
Tin Amaranth
  • 683
  • 2
  • 12
  • 23
2
votes
1 answer

cross tabulation R

I've been trying desperately to create a simple cross tabulation/pivot table of some data I have. It's a huge data.frame with around 11,000 observations and over 100 variables, so for simplicity I've created a subset to use as an example here (see…
marty_c
  • 5,779
  • 5
  • 24
  • 27
2
votes
2 answers

Calculating the difference between the count of two date fields

I have data that is provided to me that includes the routed date and the service restoration date. From that it's pretty easy to generate a pivot table that generates a table with the date of the month, then a count of received tickets (routed),…
Wiss
  • 23
  • 1
  • 4
2
votes
0 answers

Trying to access some properties of pivotal table, throws exceptions

I have xlsx file with pivotal tables, I’m using Microsoft.Office.Interop.Excel libraries to access the file and manipulate data. While I can read and even change some properties, others throw exceptions on access, for example, I can change slicer…
user2384366
  • 1,034
  • 2
  • 12
  • 28
2
votes
2 answers

Row to column transformation in MySQL

I have this result set in MySQL : ID Type Email Degignation 1000000000 202 brijesh@abc.com Entrepreneur 1000000000 234 brijesh@abc.com Engineering,Development 1000000000 239 brijesh@abc.com CTO I have many such tuples not…
Brijesh Kushwaha
  • 273
  • 1
  • 3
  • 11
2
votes
1 answer

Laravel Eloquent nested relation pivot with constraint

I am currently working with laravel 4 I am trying to retrieve collection with constraint but it doesn't work as expected model Caracteristique : public function valeur() { return $this->hasMany('Valeur','id_caracteristique','id'); } model…
lwillems
  • 103
  • 13
2
votes
2 answers

Selecting a max value from a pivot table

I built a result set using a pivot table that looks like this: customer A B C D Joe. 1 4 0 2 Sue. 2 0 3 9 How would I select the column name with the largest value from the pivot table? For instance: Joe B Sue D Seems like…
Nathan Currie
  • 33
  • 2
2
votes
1 answer

SSAS Tabular calculated measures missing from Power View fields list

I have defined a calculated measure named "Gross Margin" for my "FactInvoiceLineItem" table. I can see this measure in the Measures dimension (along with several others): These measures work fine in a PivotTable, but they are absent from the field…
3bh
  • 806
  • 1
  • 6
  • 12
2
votes
1 answer

How to apply multiple filters to multiple value fields in a pivot table?

I use the following data... ...to create the following pivot table. I want to apply the filter "FLORIDA SALES = Y" only to the first values column, and the filter "S.EAST SALES = Y" only to the second values column, to produce a pivot tables that…
Trevor D
  • 743
  • 4
  • 14
  • 34
2
votes
1 answer

SQL - create pivot table/cross tab from raw data

What is the best way to transform the layout of a flat table into a crosstab/pivot table with SQL. there is no need to calculations. The first column of the raw table will be the first column in PV table, second colum of raw will be spitted in…
Alg_D
  • 2,242
  • 6
  • 31
  • 63
1 2 3
…
99 100