Set expression on row level

[khanashique]

Hi experts,

I have define a set expression which works on specific condition, but it doesn't work on row level without condition:

eg: (sum({<Year = {2017},Item = {'Books'}>}sales)-sum({<Year = {2018},Item = {'Books'}>}sales))*sum({<Year = {2018}>}amount) --> this expression works.

but the same expression on row level in a table without condition doesn't gives the expected result.

eg: (sum({<Year = {2017}>}sales)-sum({<Year = {2018}>}sales))*sum({<Year = {2018}>}amount) --> this expression works.

Do i need to add some other expression to my current set expression, kindly advise.

Thanks,

MAK.

[Anil_Babu_Samineni]

You have only Item dimension or anything else?

[khanashique]

One item condition was just an example, to check if the expression works...

[khanashique · Accepted solution]

i was able to solve the expression, please see below:

sum(<Item>sales)/sum(<Item>amount)