| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specify pivot table to hide 'earlier than' grouped data start
Thanks - I used your first method and it works a treat
-- KenY "Shailesh Shah" wrote: Try this, With ActiveSheet.PivotTables("PerfSummary").PivotFields ("end date of BV data") 'to hide first date starting with "<" If Left(.PivotItems(1), 1) = "<" Then .PivotItems(1).Visible = False 'to hide last date starting with "" If Left(.PivotItems(.PivotItems.Count), 1) = "" Then .PivotItems(.PivotItems.Count).Visible = False End With or use Dateserial function with your variable named BVGrpStart. Regards, Shah Shailesh http://in.geocities.com/shahshaileshs/ (Excel Add-ins Page) *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to hide data that's less than 1 in a pivot table | Excel Discussion (Misc queries) | |||
| how to show repeating data in pivot table (not grouped) | Excel Discussion (Misc queries) | |||
| Format a Grouped Date in a Pivot Table | Excel Worksheet Functions | |||
| Pivot Table - hide if no data | Excel Discussion (Misc queries) | |||
| how to change date formating-grouped by month in pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
