show stacked dimension in Totals bar

[#1]

Hi,

I'm showing a stacked bar chart across two dimensions, but the legend dimension isn't showing stacked in the total bar:

Is there an easy way to do this (i.e. i'm missing a setting) or will this involve additional expressions (creating an 'All' value for the X dimension)?

[ramoncova06]

how are you calculating your total bar ?

are the x values associated with it ?

[#3]

Hi Ramon,

No, i just checked Show total in the dimension limits tab, no calculation (on my part) for the Totals bar.

Cheers,

[MarcoWedel]

please provide sample app to check.

thanks

regards

Marco

[Anonymous · Accepted solution]

Hi,

it is intresting but I dont know if you can do this (checking the show total)::

I try there but it work like your app.

[#6]

Hi,

Thanks everyone, it looks like it's a no-go. I thought the dimension limit 'Total' worked exactly like the Total qualifier, but there seems to be a bit more to it:

Show Total

The chart will display a total for the selected dimension when this option is enabled. This total behaves differently than the expression total, which is still configured on the Expressions tab of the property dialog.

I was hoping to avoid scripting in a 'Total' value for the dimension (or adding a 1 column bar chart next to the chart) but it currently looks unavoidable.

Thanks again,

Richard