I need a way to filter an icon conditional format by more than just its field value
I'm creating an info graphic with 4 sections placed in various areas of the graphic. Each section of the graphic represents a product that a manufacturer sells. Each section has a percentage of plan value that the product sale has achieved. In each area of the graphic that represents one product, I'd like to show an up or down arrow, which represents the percentage direction of sales (up, down or sideways) against plan.
The problem I'm having is that a icon condition widget allows me to select a value field that represents the aggregate of the data set, and not the individual product (the data is a financial summary of 4 products), which is filtered using a Set Analysis to produce a KPI chart. I need a way to either base the conditional widget on the KPI chart, or a more flexible way to filter a conditional widget.
Hope I've been able to explain this reasonably.
If you have a creative solution to this use case, please let me know.