# Tagged Questions

**0**

votes

**1**answer

78 views

### Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...

**0**

votes

**0**answers

47 views

### Filter excel pivot table using date range

I am exporting an MS Project file into an Excel spreadsheet. I would like to be able to pivot my tasks by assignee, by task etc.
I would like to be able to filter the tasks such that if the start ...

**1**

vote

**0**answers

209 views

### Pivot Tables - Filter Behavior, Limiting Filter Drop Downs Based on Previous Filters

I am working in excel 2010, and I have a question about pivot table filter capabilities / limitations. I tend to use complex, extensive pivot tables for data analysis/data accuracy on huge datasets, ...

**0**

votes

**1**answer

62 views

### How to delete days with no data?

I have the flow data for 49 years for 15 min interval. I've used pivot table to get the daily average value of flow.
After copy-pasting from pivot table and using filter to remove the blank flow ...

**0**

votes

**1**answer

141 views

### Pivot table on filtered data

There doesn't be a way in Excel to run a pivot table on an Excel sheet that already has columns filtered. Thus far, I've had to manually copy and paste the sheet into another sheet and then run a ...

**0**

votes

**2**answers

595 views

### Excel use columns in one table to make another table

I have an csv data dump which is a flattening of related tables from a sql database. So to simplify it looks like this.
| col1 | col2 | col3 | col4 |
+------+------+------+------+
| A | Ad | B ...

**0**

votes

**1**answer

592 views

### Single source worksheet, and multiple pivot tables using filtered data

How does one manage to create a workbook, where one worksheet is the master source data, but multiple pivot tables need to be created with the same set of "row labels" and "summed values", but ...

**0**

votes

**1**answer

290 views

### Sort Excel Pivot Table By Month

I am trying to sort data in a pivot table. I am hoping to end up with a table that has row labels with my data types, and then 12 monthly columns with a count of each type in each column. So far I ...

**0**

votes

**1**answer

1k views

### Excel: Filter Pivot Table from Another Sheet / Duplicate Filters Across Sheets

I am working with Excel for Mac 2011.
I have several different pivot tables that each organize data for graphing on a summary sheet. Every pivot table should be filtered the same way.
Questions:
...