| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove rows from Pivot Table
I have created a Pivot Table with multiple rows of data for each date.
However, I would like to automate so that only the last 2 days of data is visible. I am able to get the last 2 days showing but can't seem to automate removing all the rest of the dates. vD = FormatDateTime(Now() , 2) vD1 = FormatDateTime(Now() - 1, 2) With ActiveSheet.PivotTables("PivotTable2").PivotFields ("Day") .PivotItems(vD).Visible = True .PivotItems(vD1).Visible = True End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002:How to remove sub total rows in Pivot Table ? | Excel Discussion (Misc queries) | |||
| Pivot table - remove worksheet | Excel Worksheet Functions | |||
| Can you remove duplicates from Pivot Table? | Excel Discussion (Misc queries) | |||
| How to remove the row totals in pivot table? | Excel Programming | |||
| how to remove "(All)" in a pivot table using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
