Vertical Totals In Bar Chart

[stevietm]

Hi All

Please look at the picture.

I have a hard time to explain what i want , but maybe there is someone who understands and can help me.

Kind Regards

Stevie

[swuehl]

Stevie,

I assume that you know how to create the stacked bar chart, so it's all about the percentage calculation, right?

I wouldn't use the relative object for that, instead use as expression

=sum(Value) / sum(total Value)

if you want to see the share across all products and months (product add up to 100% in the year), or

=sum(Value) / sum(total<Month> Value)

if you want to see the share across all products, but related to the single month (products add up to 100% in each month)

See also attached.

Regards,

Stefan

[stevietm]

Hi Stefan

Thanks for the help it worked.

Kind Regards

Stevie

[swuehl]

You're welcome.

If your question(s) are answered, please set the status of your threads appropriately and mark helpful and/or correct answers. This helps others to find relevant pieces of information more easily.

Regards,

Stefan