I have a Pivot Chart controlled by a slicers, which has three buttons (categories). When I click one of the slicer buttons I would like to see a MAX value (as a bar/column) appear on the chart, which changes when I select a different slicer button. Currently, the MAX value that is displayed is for the whole dataset isn't changing when I select a different slicer button.
Is there a workaround for this?!