Expression in bar charts with multidimension

[tizianonear]

Hi,

I have a table like this:

Year	Key	Field	Type	Value
2008	001	Object	A	2
2008	001	Object	B	3
2008	001	Player	A	18
2008	001	Player	B	3
2008	001	Book	A	7
2008	001	Book	B	12
...	...	...	...	...

and I want to creare a "Horizontal Stacked Bar Chart"  with dimension:

Stack = Key

Bar = Field

and measures:

(Sum(Value)/sum(total(Value)))

Measures need to show the percent.

It show in this way:

but I need to show something like this:

I think that I need to modify the Measure expression to calculate the percent in a way that is right to take the full value, but I don't know how.

Thanks to all

[agigliotti]

could you attach a sample app woth mock data?

[dplr-rn]

try this Sum(Value)/sum(total<Key> Value)

personal e.g. below

Sum(LineSalesAmount)/Sum(total<Year>  LineSalesAmount)

Year is the stack