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

[jonathandienst]

I am not sure that I understand your data - if every article is associated with a name and with a size, then your expression should work. To get the ratio, you would need:

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

If that is not working then your data is nor organised the way I thought. You might want to provide extra information, preferably a small sample with some representative data the the chart that you are trying to build.

[#3]

thx for ur answer,

the problem is that u can sell an article and retoure it and the same article can then be sold again.Thats why u need the articlenumbe rin calc!!

[Anonymous]

Maybe it makes sense to create a "real field" in the data model instead of using calculated dimension.

[#5]

i dont calc the dimension.

sorry for my bad english but I want to calc this as my measure!

[#6]

I think i have a problem with my calc!!!

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

This calc gives me the amount of both "retoure" and "sale" back but it should only give me the amount of "sale"!!

Someone see the problem with my syntax

[sunny_talwar]

Eric is your data model well connected? If it isn't then that could be one of the reason that set analysis doesn't work. Would you be able to share a sample to further investigate this?

[#8]

the RET table is the only table and it is not connected

[sunny_talwar]

RET table is the only table in your database? So you have just one table which includes all the fields?

[jonathandienst]

I am confused if [art_ret]= {'sale'} gives you sales and returns (retour). What does [art_ret]= {'retour'} give you?

I think you would be better off uploading a small sample app with some representative data.