expression issue

Thu, 02 May 2013 12:31:36 GMT

below is my table

id value tradepurpose date

1 100 abc T

1 150 xyz T-1

i have created a straight table and the expression is not working properly:

D D Expression Expression

id tradepurpose T value Change %

1 sum({<date=T>}value) alt(sum({<date=T>}value) /sum({<date=T-1>}value)-1,1)

answer i am getting is below:

id tradepurpose T value Change %

1 abc 100 100%

1 xyz 0 -100%

i want the answer to be: (is it possible having trade purpose in the dimension

id tradepurpose T Value Change %

1 abc 100 -33%

thanks

Re: expression issue

Thu, 02 May 2013 13:23:25 GMT

hi all

any help on the above

thanks

Thu, 02 May 2013 14:29:45 GMT

resolved by myself