John Jairo V
Well-Known Member
Hi!
This time I come with a question about Pivot Tables and VBA, and show details by double clicking in the grand total, for a list of those who are in the pivot table in the grand total different from 0.
Achievement make the filter value for the "NIT CLIENTE" field , but when you double-click the grand total ( bottom right of the PivotTable cell ) shows me as detail all values , when I would only show me the records corresponding to the filter made.
I know a way to do this is by double-clicking in total of each different record different of 0 with a loop, and make another loop tru sheets report to join them into one, but the idea is to find a way to do it without that loop to speed the code.
Thx in advance for your answers. Blessings!
This time I come with a question about Pivot Tables and VBA, and show details by double clicking in the grand total, for a list of those who are in the pivot table in the grand total different from 0.
Achievement make the filter value for the "NIT CLIENTE" field , but when you double-click the grand total ( bottom right of the PivotTable cell ) shows me as detail all values , when I would only show me the records corresponding to the filter made.
I know a way to do this is by double-clicking in total of each different record different of 0 with a loop, and make another loop tru sheets report to join them into one, but the idea is to find a way to do it without that loop to speed the code.
Thx in advance for your answers. Blessings!
