expression issue

[#1]

hi

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

[#2]

hi all

any help on the above

thanks

[#3]

resolved by myself