Stacked bars in Active Form

Post Reply
schlemiel29
Posts: 68
Joined: Tue May 08, 2012 8:29 am
OLAP Product: TM/1
Version: 11.8
Excel Version: Excel 365

Stacked bars in Active Form

Post by schlemiel29 »

Hi All,
I'm facing the following problem:
I want a stacked bar chart using Excel. So no special functionality of PAW available.
I have a number of periods, used for rows, and a number of materials used for columns. Both are defined by a dynamic Subset via MDX.
So I need to put the materials in the columns, because this dimension should be stacked, but the number of columns is dynamic. I used the trick to define a table (Ctrl-T) for the grafic, but this does not solve the varying number of columns of the view.
Any idea or hint?
BR
Dirk
Post Reply