Hi all,
This is yet another problem with hiding specific pivotitems.

The issue I am having is with a set of pivotitems based on a grouped dates field (in this case groups of 7 days).
What I am looking to do is selectively hide the "<" and ">" date items at the start and end of the list.
Tried, all the usual suspects, (.manualupdate, etc.) to no avail. Any suggestions?
Can't upload the file for company reasons, but can be easily replicated with a column of dates and a corresponding status for each.
Field setting "Show items with no data" must be set on to show the .GT. .LT. items.

Grouped Date PivotItem.jpg

Sub HideShowFields()
Dim pt As PivotTable

Dim pi As PivotItem

    Set pt = ActiveSheet.PivotTables("pvtPourStatus")

    pt.ManualUpdate = True
        For Each pi In pt.PivotFields("Pour Date").PivotItems
            Select Case Left(pi.Value, 1)
                Case ">", "<"
                    pi.Visible = False
                Case Else
                    pi.Visible = True
            End Select
        Next pi
    pt.ManualUpdate = False
End Sub