Dynamic Top 10 list
How can I create a dynamically changing top 10 list to chart in Xcelsius 5.0?
For example, we have 30 accounts in one month and we want to create a top 10 list of the accounts for that certain month. Then in the next month we gained 5 accounts and we want to update the list accordingly. In Xcelsius, it seems that when you are populating data, it has to be a set amount and the range will not change if new values are added to it. I understand that if it was a set number of accounts, then I could easily create a top 10, but with accounts constantly being added and removed, I am unable to figure it out. Can anyone offer any suggestions?