100% Stacked Bar Chart based on Active Form?

Post Reply
User avatar
macsir
Community Contributor
Posts: 551
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

100% Stacked Bar Chart based on Active Form?

Post by macsir » 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?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

User avatar
macsir
Community Contributor
Posts: 551
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: 100% Stacked Bar Chart based on Active Form?

Post by macsir » Tue Oct 16, 2018 9:05 pm

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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

User avatar
paulsimon
MVP
Posts: 647
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: 10.1.1 and 10.2.2
Excel Version: 2013

Re: 100% Stacked Bar Chart based on Active Form?

Post by paulsimon » Wed Oct 17, 2018 8:47 pm

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

User avatar
macsir
Community Contributor
Posts: 551
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: 100% Stacked Bar Chart based on Active Form?

Post by macsir » Wed Oct 17, 2018 9:05 pm

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. :P
stacked.PNG
stacked.PNG (50.71 KiB) Viewed 92 times
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

Post Reply