I want the following: to be able to filter on the baseline $ column but not have that filter affect any of the numbers in the current $ column like in the chart below. I have tried set analysis on the current $ column to exclude any filter from Producer but it still keeps filtering out the "Jody" producer because she has no baseline $ amount.
Sorry Stephan will send a model if my description below doesn't help.
Very simply - when I filter on "Ginny", then "Jodi" goes away in my chart. I want Jodi to stay because she has dollars in the Current $ column. I am struggling to find the set analysis the will force any producer to rename (no matter what producer is filtered on) if they have an amount in the Current $ column.
Actually the Baseline column is a simple Sum(Baseline)...I want it to respect any filters. My issue is I want the Current $ column to disregard any filters if there is an amount greater than 0. In my example above the Jody record goes away when I filter on Ginny.