Tag: pivot-table

2 Can I use table relationships in formulas? 2014-09-11T13:26:42.537

2 Pivot table with two headers in MS Excel 2014-09-24T04:43:49.347

2 Excel Formula...Complex...Invoice tracking without inputting info into multiple spreadsheets 2014-10-10T01:15:38.067

2 Drawing independant columns in a pivot table 2015-03-10T17:25:49.763

2 Average of Count of Cells for Day of Week in MS Excel 2015-04-02T12:36:28.957

2 Pivot Table Slicers. Can I ensure one specific item is always selected? 2015-04-15T05:11:48.777

2 Excel pivot table - unable to get graph to display correctly 2015-06-02T08:13:55.660

2 How can I use Excel to monitor my payable? 2015-06-05T03:02:45.993

2 Is it possible to add a custom calculation for a top level row total in a pivottable? 2015-06-24T15:10:50.173

2 Possible to create and switch between views/configurations of a pivot table 2015-07-13T18:37:35.403

2 Excel survey data pivoting, plotting and analysis 2015-11-06T16:57:35.367

2 Dates in Excel 2013 Pivot Tables 2015-12-13T19:45:18.190

2 Top Percentile by Group 2015-12-26T23:07:10.727

2 Excel 2013 Pivot table, how to filter rows/columns before pivoting 2016-01-26T15:09:55.267

2 Expanding specific sections of a pivot table in Excel 2016-03-07T21:46:06.837

2 2 columns of data in Pivot Table 2016-05-09T11:30:07.533

2 Excel creating multiple scatter plots from one table 2016-08-17T18:21:18.040

2 How to compare fields in Pivot Table 2016-11-11T23:10:32.197

2 Excel Structured Breakdown 2016-11-29T14:39:45.487

2 How can I remove the expand/collapse buttons for only some fields in an Excel pivot table? 2016-12-07T01:57:26.803

2 How to create a dynamic pivot table using categories? 2017-01-09T13:00:46.623

2 How to connect existing slicers to new pivot charts? 2017-04-06T06:54:07.927

2 How to remove a duplicate value on slicer in Excel 2017-11-18T07:12:37.613

2 Is it possible to set an Excel Pivot Table filter value to a cell reference? 2017-11-24T18:31:23.730

2 Use a Pivot Table to summarise a ledger 2017-12-22T17:04:50.890

2 Grand Total Not Displaying Correctly for Pivot Table's Calculated Field 2017-12-25T22:15:14.190

2 How to add from pivot table 2018-01-11T10:09:18.917

2 Filter PivotTable on date range with blank rows showing 2018-01-11T17:25:23.067

2 Creating a graph that groups data by date and category 2018-01-30T19:23:32.847

2 Excel PowerPivot Relationships 2018-03-13T08:28:04.657

2 How to change the format of a date in a Pivot Table? 2018-04-04T10:24:52.347

2 Excel Pivot with percentage and count on bar graph 2018-06-01T07:33:00.013

2 Pivot Table won't show correct data relating to the row names 2018-08-15T23:36:55.133

2 Excel chart formatting lost when Refresh All or individual Right Click on Data > Refresh 2018-10-30T11:15:02.057

2 How do I stop PivotTable fields from expanding when the data set changes 2019-01-24T01:14:12.013

2 Use GETPIVOTDATA for grouped data 2019-01-28T18:09:21.610

2 Excel: Pivot chart of values using value-stdDev as error bars? 2019-04-02T13:00:24.250

2 PivotTable Calculated Item IF Statement Issue 2019-04-05T14:34:01.693

2 Excel doesn't print all active sheets to PDF 2019-09-18T11:33:40.903

1 Excel 2007 | Remove blank fields from pivot tables 2009-08-18T15:17:39.843

1 How do I change the format of group by data in Excel 2003 pivot tables 2009-08-31T11:43:50.923

1 External data for pivot table 2009-09-17T10:40:40.707

1 Pivot table - calculations across totals 2010-01-14T15:34:49.090

1 Combining multiple Excel 2007 tables into one PivotTable 2010-01-16T23:58:47.977

1 Sorting in Pivot Table on how data is summarized, not just the value 2010-03-18T18:57:20.340

1 grouping by date in excel and removing time in a pivot table 2010-05-14T16:04:10.837

1 Microsoft Excel - how to keep adding raw data to pivot table 2010-06-05T22:54:05.903

1 Excel 2007 Pivot Tables: Refreshing upsets my manual formatting 2010-06-09T18:30:07.493

1 Excel 2007 Pivot Tables: Overlapping issue hampers my summary sheet 2010-06-11T13:47:07.640

1 Excel Pivot: How can I show the % of the sub-total against the Grand total? 2010-07-05T13:36:02.087

1 Auto refresh pivot table on internal data change 2010-08-02T04:25:30.563

1 Excel file with PivotTables - reduce size 2010-08-18T14:35:11.603

1 Excel pivot table group all months by year 2011-01-25T08:34:07.827

1 Determining whether VBA is necessary in Excel, or if a pivot chart/table can suffice 2011-01-25T19:28:23.520

1 How do I show the average by month in a pivot table? 2011-03-28T12:42:18.713

1 Excel 2010 pivot table/chart - how to filter a date range without empty rows 2011-04-11T03:01:13.373

1 Using a PivotTable to Count Items in Access 2011-04-19T15:24:03.717

1 Excel 2007 pivot table where columns are custom values not directly in table (sort of) 2011-05-07T18:57:22.577

1 Move Excel Report to Database Solution 2011-05-17T13:17:13.827

1 create tree structure in excel 2010 pivot table 2010-12-08T07:36:28.687

1 Excel - Clickable link in pivot detail 2011-06-23T13:50:20.650

1 How to create a Pivot Graph that only looks at the Day in Month instead of Full Date? 2011-07-15T12:31:48.920

1 Excel 2010 pivot tables 2011-07-31T18:55:39.017

1 "clustered column" PivotChart using percentages instead of values - Excel 2010 2011-08-03T01:22:10.680

1 How do you group by values in a pivot table 2011-08-30T20:47:49.050

1 Hyperlink to a filtered pivot 2011-09-17T16:15:52.807

1 Excel PivotTable % of a specific value 2011-10-21T20:57:29.213

1 Can I group all rows with a percentage of column total less than 1% in an Excel 2010 pivot table? 2011-12-30T21:34:42.413

1 Excel: Multiple calculations on data in pivot-table 2012-02-09T09:09:00.100

1 when creating a pivot chart in MS Access, how to prevent it from updating with every change? 2012-02-21T00:58:47.823

1 Microsoft Excel - Count the number of values each name has in a single column 2012-02-23T16:45:20.550

1 How to easily change columns into rows in Excel? 2012-04-15T15:38:10.683

1 Excel 2010 Pivot Table: How can I expand/collapse a subset of records beneath a distinct set of records? 2012-07-12T17:30:27.007

1 Transform two-dimensional tables to one-dimensional list in Excel 2012-07-23T12:10:32.270

1 Excel Pivot Table - Change default font 2012-08-28T13:48:41.433

1 Excel pivot table: grand total of hours 2012-10-11T07:12:53.877

1 Excel 2007: The empty look of a pivot table 2012-10-11T09:24:35.607

1 How may I retrieve data from an Excel table based on a variable number of criteria? 2012-10-15T09:33:48.170

1 insert calculated field in pivot table based on previous row of one column 2012-10-19T17:42:41.290

1 find the next due date after today within a group in an Excel PivotTable 2012-10-23T15:27:44.780

1 Excel: How to position image dynamically in Excel? 2013-01-13T23:17:35.050

1 Pivot with mode of service time values 2013-02-04T12:15:23.997

1 Excel (pivot) diagram to connect dots in a curvediagram no matter if an entry is missing 2013-02-12T08:46:14.370

1 Excel: How to hide/remove scrollbars from Pivot Table Slicers? 2013-02-12T12:02:10.263

1 Transform data in Excel 2013-03-10T10:31:42.603

1 Adding 80% horizontal goal line to pivot chart 2013-03-18T14:32:30.617

1 Pivottable selection using slicer, is there any way to get source data? 2013-03-19T15:43:05.977

1 How can I edit the legend in an excel pivot chart 2010 2013-03-30T23:35:50.043

1 pivotslicer connected to multiple pivotcharts 2013-04-03T08:22:32.920

1 Excel - Finding all values in one column for unique values in another column 2013-06-05T18:23:49.557

1 Excel - One Slicer To Rule Them All 2013-07-19T20:26:54.343

1 PivotTable -- how to sum the result of a countif formula by group? 2013-07-25T15:58:54.920

1 Aggregating Columns In Excel 2013-08-11T12:00:30.877

1 Calculate frequency across columns 2013-09-26T04:12:37.680

1 Chart Categories: How To Combine X-Axis Categories 2013-11-07T00:40:02.843

1 Pivot Tables - Filter Behavior, Limiting Filter Drop Downs Based on Previous Filters 2013-12-16T20:29:30.933

1 Sum two columns of a pivottable into a third column 2014-01-08T20:33:08.220

1 Excel pivot tables: reverse running total 2014-01-29T16:14:47.940

1 Using getpivot in excel to create flexible reports based on user inputs 2014-01-29T22:12:05.037