Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!)
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...
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.