How to convert stack bar chart 100% stack bar chart

[paulyeo11]

Hi All

I have a stack bar chart , and i like to convert it to 100% stack bar , in order to view which are the items contribution % for that period.

Seek some one help help.

Paul

[Janneke]

Hi Paul,

You can use the TOTAL qualifier.

Example:

Old expression: sum({set analysis}sales)

New expression: sum(TOTAL<period_dimension>{set analysis}sales)

Janneke.