Agreement wise Amount

[SunilChauhan]

Hi,

i am calculating amount based on agreementid.

but agrement id will not included in dimension.

dimensions are state,region

how to find amount agreement wise without taking agrrement id in dimension.

[#2]

hi tom,

probably you can use aggr function

aggr(sum(amount),agreement id)

but there might be better way of doing this

thanks

[SunilChauhan]

hi tauqueer,

actually i am taking

aggr(sum(pnrcomdebtor)+sum(booksize),agreementid)

its showing blank

is there another way to do this