Top "Pivot-table" questions

A "pivot table" is a method of summarizing data in tabular form.

Filtering pivot table columns, only count if

I was wondering if it's possible to filter a single pivot table column in excel. In other words, when you …

excel pivot-table
Count Unique values with a condition

In column A I have list of different names. In column B, I have values either 0 or 1. I want to …

excel excel-formula formula pivot-table array-formulas
Using QUARTILE in an Excel pivot table to summarise data by sub-populations

I've got a large table of data in an Excel spreadsheet that, essentially, can be considered to be a collection …

excel statistics excel-2007 pivot-table data-analysis
Pivot Calculated formula: SUM(Field1)/AVG(Field2)

I've a simple table with some amount and interval in sec by date and product name. Month | Product | Amount | Interval …

excel pivot-table calculated-columns
How to filter a pivot table using Eloquent?

I'm using a pivot table on the project I'm working with to get works of users. E.g: User::find(1)…

laravel laravel-4 filtering eloquent pivot-table
Laravel attach pivot to table with multiple values

Background I'm creating a database revolving around food allergies and I have a many to many relationship between foods and …

laravel laravel-4 eloquent pivot-table
Pandas Pivot tables row subtotals

I'm using Pandas 0.10.1 Considering this Dataframe: Date State City SalesToday SalesMTD SalesYTD 20130320 stA ctA 20 400 1000 20130320 stA ctB 30 500 1100 20130320 stB ctC 10 500 900 20130320 stB ctD 40 200 1300 20130320 …

python pandas pivot-table
Create a Pivot Table from a DataTable

I am using C# winforms to create an application that needs to turn a datatable into a pivot table. I …

c# winforms datatable pivot pivot-table
How to add a weighted average in my pivot table?

I would like to know how to add a weighted average in my pivot table. In fact, I need to …

excel pivot-table
mysql select dynamic row values as column names, another column as value

I have a legacy table of user information (that is still in active use) and I cannot change the structure …

mysql sql pivot-table