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?
TonyM14,
For dynamically changing lists you should pull a query(for the list) via QAAWS OR a webi report which updates regularly, through Live office connection. Also when trying to bind ranges for the dropdown filter limit it to some 50 rows(though u have initially 10 values to populate) so that the additions are considered.
Thanks,
Karthik
Add a comment