Hello everyone
I`m new here and I have no knowledge regarding VBA (none what so ever) so I apologize in advance
I would highly appreciate if someone could help me regarding VBA OLAP Pivot Filter for an Array
I`ve recorded a macro that looks like this:
Sub Team()
'
' Team Macro
'
'
ActiveSheet.PivotTables("PivotTable1").PivotFields( _
"[Feature Area].[Team].[Team]").VisibleItemsList = Array( _
"[Feature Area].[Team].&[T_FW_Superman]&[P_A]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_B]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_C]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_LOS]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_RIO]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_LONDON]", _
)
End Sub
My objective is to filter on the T_FW_ Superman string regardless of the ending ( I need to use a wild card)
Can someone please help me?
Thank you in advance!
I`m new here and I have no knowledge regarding VBA (none what so ever) so I apologize in advance
I would highly appreciate if someone could help me regarding VBA OLAP Pivot Filter for an Array
I`ve recorded a macro that looks like this:
Sub Team()
'
' Team Macro
'
'
ActiveSheet.PivotTables("PivotTable1").PivotFields( _
"[Feature Area].[Team].[Team]").VisibleItemsList = Array( _
"[Feature Area].[Team].&[T_FW_Superman]&[P_A]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_B]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_C]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_LOS]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_RIO]", _
"[Feature Area].[Team].&[T_FW_ Superman]&[P_LONDON]", _
)
End Sub
My objective is to filter on the T_FW_ Superman string regardless of the ending ( I need to use a wild card)
Can someone please help me?
Thank you in advance!