TM1 Forum

Hi, has anyone implemented this chart before? The problem I have is the multiple data series for the chart has to be manually fixed in advance. It can't be dynamically based on the rows or columns from the active form. Named range doesn't work. VBA doesn't work in TM1 web. Could anyone share any idea?

Alright, it ends with fixed number of data series, say top 10 or top 15. It can't be dynamic, otherwise it has to be in VBA.

Hi macsir

Not sure if you have already answered your own question. We had similar issues with a Waterfall chart. However, as the user only wanted to see the Top 6, we recorded MDX for this and then pasted it in to Excel and concatenated in the appropriate variables, and used this in the Active Form.

Regards

Paul SImon

macsir wrote: ↑Fri Oct 12, 2018 11:04 pm Hi, has anyone implemented this chart before? The problem I have is the multiple data series for the chart has to be manually fixed in advance. It can't be dynamically based on the rows or columns from the active form. Named range doesn't work. VBA doesn't work in TM1 web. Could anyone share any idea?

Thanks, Paul. Yes, the top N can be done using MDX. However my problem is that in some excel charts, the data series have to be fixed and stacked bar chart is one of them. See what I linked with red lines in legends entries section from the snapshot. You can try it also in excel if still not clear.