How do I dynamically show all of the dimensions that represent 80% of the value?
We want to show all of the brokers for whatever dimensions are selected that comprise 80% of the total value of the revenue. As the users choose a selection like Year or Market or Product, it would dynamically render the group of brokers shown based on whoevers revenue comprised 80% of their selections total.
Basically, usually a small number of brokers (maybe 10%) comprise 80% of the Total revenue. Those are the only ones they want to show. If possible, they would also like to make the 80% dynamic so that they can change that to X%.