Show Data Field After Hiding

T

Takeadoe

I found a note from someone with the same question regarding reshowing
data that was hidden after it was deselected from the drop-down list.
And yes, it is easy enough to drag it back on from the field list, but
if it involves anything more than just a sum or count, then you have to
recreate it. For instance, my rows are years. One of my data fields I
would like in the table twice - once as a sum and then again as %
difference from previous year. The reason for wanting to hide one or
the other, is I'm plotting this over time and would like to use the
same chart. Since the scales are obviously different, I can't have
them on the chart at the same time. But when I hide the percent
change, I have to go back and recreate it each time. Is this something
I have to live with?

Mike
 
Top