Tag: pivot-table

1 Excel combine rows dollar amount with matching row values? 2014-03-25T14:18:02.423

1 How can I summarize cells based on date in other cell? 2014-03-25T19:03:39.483

1 Extracting and collating data from multiple columns in Excel 2003 2014-05-07T13:28:53.160

1 Listing/grouping variables in PowerPivot table field list 2014-05-21T13:48:22.680

1 Set default expand/colapse state on pivot tables 2014-06-03T14:30:59.873

1 Excel Cross Referencing 2014-06-27T13:35:15.240

1 How to remove one column of a calculated item in Pivot? 2014-07-20T16:49:35.950

1 Excel: How to extract group of the same rows and their values into columns? 2014-08-18T19:52:06.543

1 Excel Pivot Table - Average per day 2014-08-20T13:26:19.443

1 Adding calculated columns to Excel Pivot without details 2014-09-09T12:03:12.107

1 Is it possible to make a pivot chart a subset of pivot table? 2014-10-07T15:04:45.123

1 Use data from a drop down list to populate table 2014-10-08T03:43:35.320

1 Pivot Table overlapping error 2014-10-13T09:46:04.847

1 VLOOKUP or INDEX MATCH doesn't update columns when referencing pivot table 2015-01-12T21:58:22.327

1 Advanced data consolidation in Excel 2015-01-17T01:54:57.127

1 Best practice for displaying and calculating data in a pivot table? 2015-02-06T14:03:31.297

1 Filtering values on Excel Pivot Chart 2015-02-27T13:44:37.197

1 How to calculate average daily sales for each month in a pivot table 2015-03-19T14:33:31.450

1 Multiple Label Filters in a pivot table 2015-04-01T20:32:01.817

1 How to sum up weighed normalizations of columns? 2015-04-14T12:06:43.620

1 Excel 2011 for Mac/ Pivot table / tabular layout how to "fill down?" 2015-05-23T00:37:43.150

1 Data reconciliation with pivot table 2015-05-30T10:31:09.920

1 Budget planning with Microsoft Excel 2015-06-04T10:12:24.637

1 How to keep pivot table from expanding into occupied rows and columns 2015-06-08T18:49:25.340

1 Get rid of PivotTable help on Excel for Mac 2015-06-22T21:22:18.603

1 How to get the count of the most frequent matching columns? 2015-07-10T15:07:24.600

1 Hiding pivot table field using a button 2015-07-28T12:45:50.247

1 Scatterplot of categorical values from pivot table 2015-07-31T14:51:58.653

1 Calculate/determine in MS Excel which filetype/product has been ordered first (complex table) 2015-09-21T20:13:13.140

1 Can't calculate % of row in Excel Pivot Table 2015-10-29T04:58:00.943

1 Pivot table column filters 2015-11-25T16:54:44.540

1 Calculate % of filtered values from all values in Excel Pivot Table 2015-12-06T23:32:21.660

1 How to compare one row to others in DAX in Excel 2015-12-08T10:52:42.153

1 'Count Distinct' and Min(date) in the same pivot table? 2015-12-16T06:32:51.620

1 Cannot edit Pivot Table Style 2015-12-17T15:10:17.123

1 Get tab delimited text from a specific column in excel 2016-01-02T18:54:09.903

1 name for a pivot table 2016-01-05T21:52:59.637

1 Conditional formatting between 2 sheets 2016-01-13T20:34:42.840

1 Can PivotTable create Pareto buckets? 2016-02-02T15:50:15.203

1 calculated item for Other 2016-02-09T23:52:13.587

1 Filter the Grand Total of a Pivot Table 2016-02-15T14:54:44.307

1 Preserve internal order in pivot table after using slicer/filter 2016-02-28T08:55:02.123

1 Excel Pivot Table - Deactivate colapse/expand function 2016-02-29T11:44:05.617

1 Show only data from the first to last occuring month in a pivot table grouped by month and year with "Show items with no data" checked 2016-03-08T10:12:41.400

1 Pivot table with dynamic field names in Excel 2010 2016-03-10T11:04:12.510

1 Excel Calculated fields on pivot table fields 2016-03-11T17:40:15.830

1 Pivot table from multiple datasets with transpose required (Excel 2010) 2016-03-29T13:29:18.563

1 Hide blank head rows in Pivot 2016-03-30T14:44:01.340

1 Sort Excel Pivot Table by Percentage of Count 2016-04-15T10:24:24.583

1 Excel Pivot chart with a legend summary table having SUM and COUNT of values 2016-05-25T13:12:39.947

1 Excel Pivot table layout for Registrant and payment data 2016-06-08T22:27:36.723

1 Divide Sum of Field By the Sum of Another In Pivot Table Excel 2016-06-16T00:53:43.240

1 Date axis with Pivot Chart (Excel 2016) 2016-07-20T22:36:47.690

1 Need Excel pivot table independent columns and no sub levels 2016-07-30T12:35:54.187

1 Excel 2016 Pivot - Filter categories containing specific subcategories 2016-08-04T08:43:53.633

1 Excel Pivot Chart - Percentage of Rows Containing Yes 2016-08-20T03:44:33.953

1 How to make Excel 2013 and 2016 PivotTables' line color black? 2016-09-23T03:39:37.313

1 Pivot Table in Tabular Report Format presented in a vertical manner 2016-10-06T03:03:39.900

1 Excel Pivot Grouping 2016-10-10T13:51:29.403

1 How do I count rows with similar data in 2 columns as 1 data entry? 2016-10-25T14:06:34.027

1 How can I concatenate values of Pivot Table columns in Excel? 2016-11-03T06:53:42.097

1 Excel - Currency Conversion based on Average FX Rate in a Pivot Table Grouped by Date 2016-11-04T12:09:51.520

1 How can I get the number of rows in an Excel pivot table for use outside the pivot table? 2017-01-09T01:21:15.617

1 How to make a 3D pivot table in Excel based on day-ranges 2017-01-20T09:34:46.533

1 Pivot table formatting 2017-02-10T20:35:23.227

1 Create simple pivot table with Excel 2017-02-16T06:34:07.090

1 How do I extract dates from a weekly tracker? 2017-02-27T18:25:53.287

1 Which excel formula to use? 2017-03-07T19:12:33.637

1 Excel pivot table allows me to select variables for slicers that are not available in field list (where I need them to be) 2017-03-16T15:21:53.800

1 Calculating ratio of two columns in Excel pivot table 2017-03-30T16:57:42.203

1 Cleaning trailing zeros (.00) from dates so the Group function works in a pivot table 2017-06-12T11:33:52.200

1 Excel:can I simplify creation of following pivot table and chart somehow? 2017-06-28T19:04:48.493

1 Not able to sort columns 2017-08-04T15:06:59.177

1 (Joining 3 tables) Pivot Table using Excel 2016 2017-09-08T15:24:39.913

1 Synchronize custom group names across multiple related pivot tables 2017-10-18T11:30:06.660

1 Cannot group field in Excel PivotTable 2017-10-30T22:20:56.667

1 Reference Cell in "GetPivotData" Function 2017-12-05T16:05:08.610

1 Referencing a Pivot Table Value, reaching arbitrary limit? 2017-12-13T22:26:07.013

1 Student voting system in Excel: Combination Slicer and Histogram 2018-01-18T21:18:28.623

1 Pivot table grouping by week - can't get it to start on Monday 2018-01-23T11:57:51.630

1 Calculate the difference between two field counts as a part of the pivot table 2018-01-31T19:16:01.020

1 Excel Pivottable wrongcalculation 2018-02-08T07:16:04.710

1 Show the latest value using pivot table in Excel 2018-03-03T13:34:51.470

1 Show contiguous time periods without data in Libre Calc pivot table, pivot chart? 2018-04-06T14:49:54.947

1 Excel chart with multiple series based on pivot tables 2018-04-06T18:57:55.070

1 F&B Industry - How to convert 1 Menu into its components with Excel? 2018-04-17T08:00:41.050

1 Connecting two different data sources pivots with single slicer 2018-04-23T18:41:23.580

1 In excel, why can I create a relationship between Table 1 and Table 2, but I can't create one going in the opposite direction? 2018-05-07T13:11:10.620

1 Using a scroll bar to control pivot table filters 2018-05-18T17:39:28.383

1 Format the table output from 'Show Detail' on a Pivot Table 2018-06-06T10:40:46.077

1 Excel Pivot - I don't want (blank) written in my empty cells 2018-07-05T13:36:59.087

1 Microsoft Excel - Pivot Table 2018-07-06T02:03:46.273

1 Pivot chart losing format after refresh 2018-07-25T07:23:40.410

1 How to split comma-separated values for Pivot Table? 2018-07-31T13:04:33.067

1 How can I assign an asterisk to a cell which has been formatted as 'Currency' and is also used as raw data for a Pivot Table? 2018-08-18T23:31:55.717

1 How to plot timeline chart with start and end date columns 2018-08-27T08:51:33.363

1 How do I add custom, dynamic time period averages to Excel Pivot Table? 2018-08-27T19:02:15.457

1 Combine none-unified data in excel based on row-id? 2018-09-12T12:11:22.437

1 Crosstab of every possible combination of columns in Excel or SPSS 2018-11-06T15:45:53.310