Is it possible to hide rows in a PivotTable using conditional logic via VBA? If so what command should I be focusing on?
Printable View
Is it possible to hide rows in a PivotTable using conditional logic via VBA? If so what command should I be focusing on?
In VB .net through a COM object it is
Table.pivotfields(YOURFIELDNAME).pivotitems(ROWTOHIDE).visible = false
I dare say VBA will be very similar, it not the same.
Is there any way to do this through an If statement? I tried and If resourcename = " (rolled off)" then Visible = False and it didn't want to work.
you do not specify what object to make visibleQuote:
If resourcename = " (rolled off)" then Visible = False