Hello Experts,
I meet problem with filtering of my Pivot. Everything is OK when Pivot contains all the data but data can change from day to day. What I mean. Below, there is my Pivot which data depends of working day. Normally, should contains 4 machines( LamA, LamB, LamC, LamD) in workstation_id field but I have only 3 values:
My aim is to get value from Column "Suma" after filtering using below Macro for each station (example for missing workstation). If workstation doesn't visible in Pivot then variable should get value "0".
I need to this value to paste it in other excel file. Any idea how to do it ?
I meet problem with filtering of my Pivot. Everything is OK when Pivot contains all the data but data can change from day to day. What I mean. Below, there is my Pivot which data depends of working day. Normally, should contains 4 machines( LamA, LamB, LamC, LamD) in workstation_id field but I have only 3 values:
My aim is to get value from Column "Suma" after filtering using below Macro for each station (example for missing workstation). If workstation doesn't visible in Pivot then variable should get value "0".
VBA Code:
With ActiveSheet.PivotTables("Tabela_przestawna2").PivotFields("workstation_id")
.ClearAllFilters
For Each PI In .PivotItems
Select Case PI
Case "Unknown", "Lam #D": PI.Visible = True
Case Else: PI.Visible = False
End Select
Next PI
End With
ActiveSheet.PivotTables("Tabela_przestawna").PivotFields( _
"workstation_id").EnableMultiplePageItems = True
Range("F3").Activate
Selection.End(xlDown).Select
LamD_PV = ActiveCell.Value
I need to this value to paste it in other excel file. Any idea how to do it ?