I have a carrier list for which we're disqualifying carriers who have done more than 90% of deliveries for one customer. So I have a custom field built for that. However, if I just apply a parameter to filter out 0 in column 5, it is only going to filter out those CUSTOMERS that are at 90 + percent of deliveries. However, I need to filter out CARRIERS who meet that condition with any one customer. See image1 below. Carrier 1MTX LLC would still show up in the view, even if I filter out the 0. Thus the conditional filter on carrier name that you see pictured in image below.
I need to be able to allow a user to turn this condition off or on, based on what view is needed. Some users will want to be able to see all carriers, regardless of whether or not they've met qualification guidelines, while others will just want to see qualified carriers. Any ideas on how I could toggle the actual condition of the filter on or off? I can't share my workbook.
I ended up doing this. I created a column which I will hide in the view that partitions by carrier and customer, restarting at each carrier, that displays the MAX value of Customer % of Volume. Then I created a True/False filter so that users can filter on the hidden column.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…