Tag: pivot-table

67 How to "unpivot" or "reverse pivot" in Excel? 2009-12-03T19:26:49.990

22 Grouping labels and concatenating their text values (like a pivot table) 2012-07-24T17:05:37.390

18 Median in Pivot Table in Excel 2010? 2012-03-07T10:03:24.573

12 Excel 2010 PowerPivot: How do I show items with no data? 2013-09-27T12:46:14.490

10 LibreOffice pivot table group by month 2012-07-18T14:54:47.957

8 How to rotate text in axis category labels of Pivot Chart in Excel 2007? 2012-10-31T08:21:51.577

7 Percentile of order in excel pivot-table 2012-01-25T00:16:09.507

7 Excel 2010 Pivot Formatting - Can't indent and wrap fields? 2014-04-11T13:49:44.840

7 Have Pivot Chart show only some columns in pivot table 2014-09-23T20:51:47.903

6 How can I add a calculated field to a pivot table that shows the difference between two series of data? 2009-09-30T11:49:44.883

6 How to preserve sort order in Excel Pivot-table? 2011-01-26T15:57:09.777

6 How can I use multiple pivot tables on the same sheet without an overlap error? 2012-06-19T13:26:06.237

6 Show (or filter) only positive grand total in pivot table 2012-08-21T08:51:19.113

6 Is it possible to copy & paste a pivot table in a spreadsheet? 2013-05-23T12:11:46.913

6 Excel: How to clear all renamed PivotTable labels 2014-03-27T09:52:22.520

6 How to Make a PivotTable out of "hierarchical" Excel spreadsheet data 2014-03-29T00:03:27.000

6 Can I customise the new Timeline slicer in Excel 2013? 2015-07-08T16:29:30.980

5 How to filter source sheet in Excel pivot table drill down? 2012-06-29T21:20:52.033

5 How to calculate a sum of cells based on a certain value in another cell 2012-08-10T18:28:50.460

5 Pivot table on filtered data 2013-05-28T20:40:51.247

5 Can I force an Excel 2010 Pivot-Table to display text strings from my raw data? 2013-06-24T20:03:55.390

5 How to sort time column by value instead of alphabetically 2013-10-17T21:18:25.133

5 Grand Average in place of Grand Total in Pivot Table 2014-12-23T19:11:28.263

5 Excel pivot table: Show values instead of summaries 2015-03-30T19:21:03.957

5 Can I convert a list of names directly into a pie chart in Excel? 2016-06-08T19:23:53.573

4 MSFT Excel pivot table links to external data 2009-08-17T16:34:31.497

4 Grouping dates by week in a Pivot Table 2010-08-12T02:53:44.683

4 How can I make an Excel pivot table from very large text file? 2012-05-24T17:24:57.253

4 Counting "0" Stock Values Generated by Pivot Table 2012-07-16T14:22:16.417

4 Excel Pivot Chart - historical Data Filter values stay visible? 2012-10-12T10:16:19.750

4 Grouping a field in one pivot tables groups the same field in another table 2013-05-06T09:35:56.487

4 Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table 2013-10-30T16:30:04.103

4 How to change Excel Pivot table "Report Filter"s values cell formatting 2013-10-31T03:43:02.853

4 How do I create a PivotChart from a subset of PivotTable data? 2013-12-30T21:33:48.007

4 LibreOffice pivot: How to count 1 per line? 2014-01-20T03:50:54.783

4 How to add custom columns to Pivot Table (similar to Grand Total)? 2014-04-01T11:59:44.763

4 Auto formatting new pivot rows to data bars 2014-05-29T23:23:47.947

4 How to convert data in Excel to percentages of total? 2014-10-20T13:00:03.143

4 Cannot sort Excel Pivot Table by two or more columns 2016-01-06T11:21:14.397

4 Hierarchical or recursive counting in excel (preferably within a pivot table)? 2016-09-03T18:15:33.010

4 How do I add a description column to a Pivot Table 2017-03-22T03:35:22.080

4 Working with Averages in Pivot Table (Calculated Field) 2017-07-24T16:58:27.617

3 Excel - PivotTable average of count 2010-02-01T22:54:10.423

3 Dates not recognized as dates in pivot table pulling directly from SQL Server 2011-02-03T16:52:07.240

3 Pivoting concurrent start and end times into timeslots with Excel 2010 PivotTable 2011-07-06T21:37:02.520

3 Adding a cumulative sum column to a pivot table 2011-08-23T17:10:56.590

3 Excel data source reference is not valid 2011-09-01T12:16:21.620

3 How to combine multiple rows of data of a single customer in a cell as comma separated values? 2012-02-29T17:21:09.960

3 Excel Pivot Table with external Data Source parameter is not saved with workbook 2012-08-01T11:53:21.823

3 Create % of unfiltered total in Excel 2012-08-24T18:25:13.457

3 "Cannot group that selection" error when creating pivot table 2012-10-07T16:52:54.707

3 Excel pivot table: How to hide zero values 2012-10-11T07:45:51.600

3 How to group daily data by month 2013-04-25T00:27:07.407

3 Count and percentage with Excel pivot table 2013-11-19T23:28:55.043

3 Count first occurrence of one criterion based on a second criterion 2014-01-17T15:43:40.147

3 How do I find which Pivot Tables has an error in Excel 2010? 2014-01-19T09:52:02.760

3 calculated column in pivot table from power pivot 2014-06-24T21:26:04.677

3 Excel Error Bars From Pivot Table 2014-08-15T14:29:57.773

3 Count Row and Column in Pivot Table 2014-09-26T09:25:45.107

3 Calculated Fields Reference Error (#NAME?) on Pivot Table Refresh 2014-12-15T19:12:29.713

3 How to create a pivot table on a multiple answer field? 2015-01-22T16:55:04.837

3 Excel pivot table, difference between fields in the same column 2015-04-13T16:31:54.680

3 Pivot table 'page fields' usage 2015-05-24T11:04:55.483

3 Excel - How to include a count of blank cells in Pivot Table? 2015-06-03T23:42:09.187

3 Data transformation in MS Excel 2015-06-05T05:05:09.280

3 Linear date axis in pivot tables 2015-07-03T08:37:40.387

3 Excel: Identify source of pivot table data 2016-02-19T23:26:47.037

3 Line chart in LibreOffice - data in rows (type, x, y) rather than in a 2-input table 2016-07-04T01:16:49.783

3 Can I automatically sort a grouped and stacked pivot chart by a sum of values without showing this on the chart? 2017-04-30T12:05:50.163

3 How to rectify Excel error "We couldn't get the data from table in the workbook..." 2018-05-21T01:44:50.253

3 Grand total of calculated fields in a pivot table? 2019-03-29T17:08:46.197

2 How to calculate unweighted averages in Excel PivotTable? 2010-02-15T16:35:20.160

2 How best to manage my growing data in Excel? 2010-03-12T09:55:25.433

2 Keyboard shortcut in excel for expanding the pivot table row? 2010-03-24T15:08:20.687

2 Pivot Tables: how can I stop my columns from disappearing if they are empty? 2010-07-02T08:35:29.153

2 Divide pivot table data by an arbitrary column in another table 2010-07-13T14:45:09.957

2 Excel pivot table - how to sort strings as numbers 2010-12-03T15:10:03.763

2 In Excel, how to group data by date, and then do operations on the data? 2011-01-12T13:45:13.477

2 Combining more than 10 tables data in to one table 2011-04-18T09:53:16.110

2 Excel Pivot Table Date Range as Columns 2011-05-19T14:48:36.483

2 Excel PivotTable - Categories and Subcategories? 2011-06-12T15:05:22.267

2 What's the difference between PowerPivot and regular pivot tables? 2011-08-02T14:25:23.327

2 Text values in a pivot table? 2011-10-12T17:43:31.700

2 How do I capture filter information from a DataPilot table? 2011-11-04T18:09:49.520

2 Add a literal column to a pivot table 2012-01-25T01:46:32.543

2 Percent of Hidden Values in PivotTable? Excel 2012-05-24T00:46:35.797

2 Relocate filters on an Excel worksheet with a Pivot Table 2012-06-19T08:59:21.680

2 How can I create an Excel PivotTable to calculate the net position of trades? 2012-07-24T21:48:07.697

2 Excel 2003 Freezes When Worksheet with PivotTable Selected 2012-09-07T02:29:06.857

2 Can an Excel 2007 Pivot Table merge data from different tables like a database? 2012-10-08T06:44:53.883

2 Excel2007 Pivot Table: Get Percentage with respect to number of different values in a field 2012-10-31T13:43:06.740

2 How do you format the date filter selection box for Excel Pivot Table 2013-01-20T05:39:19.347

2 Referenced values in a pivot table 2013-04-17T09:05:53.707

2 How to make a pivot table with two sets of columns, each filtered differently 2013-04-22T17:41:31.230

2 Combine PivotTable with prices to calculate billings by person 2013-06-15T09:58:53.837

2 Excel 2010 Pivot table to calculate average profit/ loss 2013-07-09T08:43:44.167

2 Pivot table : absolute value of grand total in Excel 2013-07-29T20:09:54.427

2 Excel pivot table categorical variables the same in multiple columns (histogram) 2013-08-22T18:36:38.647

2 Group and Max Excel Table 2014-03-13T05:55:29.750