Using one PivotTable and switching between column fields

[DaRTH KiRo]

I have a PivotTable with names as the row and for the columns I want the user to be able to easily switch between chat total, email total, and call total, and then the values be whatever the chat, email, or call total is for the employees. Is there a way to do this without using the PivotTable Fields sidebar?

 

[mrshl9898]

You could just add them all then have a macro hide/unhide the columns you do or don't need.

Sub showchat()
Columns("C:E").Hidden = True
Columns("C:C").Hidden = False
End Sub


Sub showemail()
Columns("C:E").Hidden = True
Columns("D:D").Hidden = False
End Sub


Sub showcall()
Columns("C:E").Hidden = True
Columns("E:E").Hidden = False
End Sub