% percentage of indicator on the total of an dimension into chart

[#1]

Hello,

I met an problem i would like to have in a an chart the part of  the amount of every article on the total

In my first column, i ve

expression1 = sum(Amount)

expression 2 =sum([Amount])/sum(TOTAL<[Articles]>Amount)

The problem is that the expression 2 is always = 100% , the "sum(TOTAL<[Articles]>Amount) " react for every row  with dimension article... ...

if somebody have an solution...

thanks

[morganaaron]

Have you got Article as your dimension? If so, in that format, your <Article> exclusion in your Total command is going to mean it's only totalling over that Article.

Try dropping the exclusion and just using Sum(Amount)/Sum(Total Amount) - with Article as a dimension it should give you the percentage of the total (assuming you set the format of that expression to be show in percentage!)

[#3]

Yes, i ve article in dimension and an other date_salon ....

it s impossible to have an expression as value fix

expression 2 = sum(TOTAL <Dim2={'Value1'}>Amount) f

thanks...

[morganaaron]

I'm a little confused by your last two sentences there.

Is this what you're after? This gives you the % that each article makes up of the given dates total.