% Based stacked bar chart

[benoitgochel]

Hi all,

I have a stacked bar chart with two dimensions (Employee and SubGroupProject) in order to analyze the timesheets of the employees.

The timesheets are transactions lines with a quantity of hours and a projet-subGroupProjet-GroupProjetc.

I would like to show with a stacked bar chart the repartition in % of subGroupProject for each employee.

Eg :

But with % repartition for every employee.

I tried  :

=num(SUM([#Hours.QTY])/SUM(TOTAL(<[empl.name]>[#Hours.QTY]))) as my meseaure expression

But I got no result ...

What can I do to solve this?

Thank you in advance,

[shraddha_g]

Please Share sample app or sample data

[sunny_talwar · Accepted solution]

Try this

=Num(Sum([#Hours.QTY])/Sum(TOTAL<[empl.name]> [#Hours.QTY]))

[benoitgochel]

It worked.

Thank you very much.