Sanoj
Member
Dear All,
I have created a macro based pivot table however, I am looking for a vba code which should work on pivot's "Report Filter" and should display the value if the filter contains only single value in the drop down list else should stay as is with value as "All".
Any help? I have attached the pivot filter screenshot for better understanding. Please let me know if anymore details required.
Thanks and Regards,
Sanoj Viswam
I have created a macro based pivot table however, I am looking for a vba code which should work on pivot's "Report Filter" and should display the value if the filter contains only single value in the drop down list else should stay as is with value as "All".
Any help? I have attached the pivot filter screenshot for better understanding. Please let me know if anymore details required.
Thanks and Regards,
Sanoj Viswam