I have Type A and Type B in the pivot table and a barchart.
Type A only display integers
Type B only displays percentage
How can I set it such that when I click on Type A, the barchart axis shows integers but when I click on Type B, the barchart axis shows percentage. Dynamically changing axis based on what the type displays.