Can I make a bar chart which changes axis values based on a filter.
For instance I have a filter with two values: Product and Salesperson.
I want to show a bar chart which shows Revenue per Product, or Revenue per Sales Person, depending on what I choose in the filter.
(P.S I do not want a secondary axis). I want to see either Product or Salesperson on the X-Axis, and Revenue on the Y-axis.