complex calc in barchart

[#1]

Hi comm,

i have a bar chart in which i want to show the ratio between sales and retoure of an article.

The article is the articlename plus the size. Its a combined Dimension btw.

My problem is that in the database every article is unique, so i have an articlenumber that unique and i need to do the calc over the articlenumber. But i cant show it in the chart cause its to big. Thats why i have articlename and size as dimension.

So i have sum of sales and sum of retoure like:

Sum({$<[art_ret]= {'sale'}>} amount_RET) //same with retoure just change {'retoure'}

but i dont know how to aggr with my articlenumber when articlename and size are a dimension.

Hope someone can help, thanks in advance!!

-Eric

[#2]

like I stated above it doesnt matter because it allways gives me back everything.

The problem is the syntax i my eyes. Because the data cant be ´the problem because there is no other table!!!!

[sunny_talwar]

So does this also give you all the data?

Sum({$<[art_ret]= {'retour'}>} amount_RET)

[#4 · Accepted solution]

i used an other coloum now and it works!!

mistake from me sorry for that!!!