Stacked Chart Type

[jduenyas]

Hi all experts.

How do I create a stacked bar chart that each column fills the full height of the chart and each component in the column fills its relative height within the column?

Thanks

[maxgro]

like this?

[jduenyas]

Yes!

[maxgro · Accepted solution]

the chart has 2 dims

Product Group

Region

and 1 expression (the bold part is the interesting one)

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>}  Sales )

/

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>} TOTAL <[Product Group]> Sales )

[jduenyas]

Mine shows like this:

[jduenyas]

Yeah. It works.

Thanks

[maxgro]

PFA