pivot table filter

I have a raw dataset that updates each day to include the latest day. I have a number of different pivot tables and one is to show a view for the previous day. It is a 2003 workbook although I did create it in 2007. Based on advice found on google and the Creating Reports for Each Region or...

Hello VBA Pros, I am trying to edit the below code so that if the filter Items do not = Month_Name and are not selected. i.e. If Month_name = March then March must be the only Month visible so I need to add <>Month_name then .visible = false, I havnt been able to figure out the correct way to...

I have a filtered column and would like for it to match a report filter on a pivot table. Is there a way to do this? Right now I have to go in manually and uncheck the ones to make it match the filtered list in column B. Thanks.

Hi All, I'm trying to get my pivot table to respond to a VBA command to filter based on a xlValueIsNotBetween filter type. But I keep getting a Run-time Error '1004': Application-defined or object-defined error Here is the code I'm using. Can anyone give me pointers on why this isn't...

I have a huge spreadsheet with about 3000 orders listed down the first 3000 rows. Beside each order in the next 2 columns is an ingredient and a usage level. If the order uses more than one ingredient (almost all do), the next row lists the same order number but with the next ingredient and...

I have a spreadsheet that list repairs for parts. I would like to build a pivot table that show the top 20 most profitable margin repairs by part # (Column G) and description (Column J) with the percentage of warranties (Column E) for those repairs. I am using Excel 2007 but I am not sure what...

Hello - I am trying to customize the date filter function on a pivot table to show the last 90 days (or last 3 months would be even better). I attempted to put a formula, "=now()-90" into the date filter dialogue box, but excel won't allow it. Is there a way to do this? I would ultimately...

Hi, How to filter Sub-total & grand total in a pivot table. I can able to filter by specific fields. But i don't know how to filter Sub-total & grand total in a pivot table. Please help. Thanks in advance.