I have a chart that uses hierarchy data. I would like the chart to maintain two hierarchy/treeview items (Interest Income, Fee income,etc...) and have have the ability to change around regions (Which is also in a hierarchy/treeview, North, Northeast,etc...). I have the hierarchies in drill down groups also. Is there any way to do set analysis like Sum(${<measurement={Current hierarchylevel}>}Amount)?
If this is posted to the wrong place, please advise what place to send this to.
I believe I will re-ask my question. I have a field with 50+ non-repeating values. How can I create a dimension in a chart that uses just 2 or 3 values from that field?
