I am trying to build a pivot chart where I only show one of my values at a time (e.g. Dollars, Units, Price, etc.). I want to be able to quickly change which of those measures I'm looking for 10 categories over a weekly time period. Is there a way to quickly isolate one value at a time in a pivot chart while allowing me to retain all of the values in the values field so that I don't have to update the formatting each time I want to change measures?
The end goal is to create one chart that has an individual trend line for each of the 10 categories but with the line being based on a changeable value. I only want 10 lines (one for each category) visible at a time (I don't want a line for price to show up at the same time as a line for dollars).