I am looking to build a Dimension Dynamic Reference Line in a Pareto Chart. Basically, I would like to choose the bar (let's say by country) where the cumulative Sales (via rangesum(above(...)) hits or 1st exceeds 80%.
Example:
US: 40%
Canada: 30% / 70% Cumul
Peru: 8% / 78% Cumul
Ecuador: 7% / 85% Cumul
So I'd like the dynamic line to be referenced on Ecuador so the user can see the <80% and > 80% rather easily. I can accomplish this somewhat by coloring the bar and/or lines in a combo chart dynamically but am struggling to pick a dimension when a measure goes over 80%.
Hope that makes sense. I don't have a qvf to share as it has sensitive data but hope this is clear enough.
