Macro to toggle data fields on pivot table

[AndrosoSabroso]

Hi! I am trying to get a single macro to show and hide a data field in a pivot table.
The code I am currently using is the following:
If Sheets("Test").PivotTables("Testeo").PivotFields("Comercial").Orientation = xlRowField Then
ActiveSheet.PivotTables("Testeo").PivotFields("Suma de Comercial").Orientation = xlHidden
Else
Sheets("Test").PivotTables("Testeo").PivotFields("Comercial").Orientation = xlDataField
End If
It seems like the condition is not working properly, could you guys helo me out¿

 

[Domenic]

See original post at the following link...

Flexible macro to toggle Pivot table data fields on and off

Hi! Thanks for checking this thread I am new to VBA and I am working on a project to create an interactive dashboard for the finantial statements of the company, spanning a couple decades of data. I have already figured out the slicer part of the dashboard to filter dates, however, I have not...

www.mrexcel.com

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.