Top "Pivot-table" questions

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

Use Excel pivot table as data source for another Pivot Table

I have a Pivot table in excel that is using a raw table as its data source. This pivot table …

excel pivot-table
refresh both the External data source and pivot tables together within a time schedule

In my last post Auto refresh pivottables data in excel on first run, i found that on my first execution …

excel pivot-table vba
PivotTable's Report Filter using "greater than"

I have a pivot table which has one of the fields (Probability) in a Report Filter. Its values are percentages …

excel pivot-table
Pivot in Excel without aggregation, to show text, not numbers?

Let's say I have a table like this: Country Region Mytext USA North a USA South b Brasil North c …

excel pivot pivot-table
Changing the Date Format for GROUPED dates in a PIVOT TABLE

I'm working in Excel 2010 Let's say you have a legitimate date field in your raw data with dates such as 1/1/2015. …

excel excel-2010 pivot-table
Convert matrix to 3-column table ('reverse pivot', 'unpivot', 'flatten', 'normalize')

I need to convert the Excel matrix FIRST in the table LATER: FIRST: P1 P2 P3 P4 F1 X F2 …

excel matrix pivot-table unpivot powerquery
getting the value of an extra pivot table column laravel

I have a phone_models, phone_problems, and a phone_model_phone_problem pivot table. The pivot table has an …

php mysql laravel many-to-many pivot-table
Sort by "Grand Total" Column in Excel PivotTables?

As per an explanation found here by Mac CPub fro Excel 2011 (for OS X) supposedly you can sort "Grand Total" …

excel pivot-table excel-2011
Is it possible to Pivot data using LINQ?

I am wondering if it is possible to use LINQ to pivot data from the following layout: CustID | OrderDate | Qty 1 | 1/1/2008 | 100 2 | 1/2/2008 | 200 1 | 2/2/2008 | 350 2 | 2/28/2008 | 221 1 | 3/12/2008 | 250 2 | 3/15/2008 | 2150 …

linq pivot-table
PostgreSQL convert columns to rows? Transpose?

I have a PostgreSQL function (or table) which gives me the following output: Sl.no username Designation salary etc.. 1 A …

sql postgresql pivot-table dynamic-sql crosstab