So should the gray line remain constant regardless of what is being filtered out? Or the value should also change?
This is a great question and as I went to answer it I think I'm beginning to see my problem.
I need the gray line to be filtered for everything EXCEPT the retailer. I tried to set up almost like a dummy retailer filter with a LOOKUP(min([Customer],0) and then putting that in the filter which works...unless I filter out the minimum value, then the whole graph dissapears.
I'm not sure what I'm trying to do is even possible / logical. Basically want the colored lines to represent a table calculation of what percentage each retailer has a market share. The filter for those would only effect which lines are shown. The other filters in the sheet would change the value of the total sales which then would change the table calculation of market share.
Working on uploading a .twbx today for better explanation. Thanks for the interest!