Problem with Partial Sum

[#1]

i m designing a complex pivote table that has conditions on several row for example filed Account group=Banks if negative it will display zero if positive it will show the number.

the issue is that when i choose partial sum it calculate the banks even if it is negative and has a zero value.

any solution

[lironbaram]

hei

you need to use Aggr function

if you can be more spesific about the expression

i can be more accurate with the answer

[#3]

i have in the expression :

if (sum(amount)<0 and dimention=Banks,0,Sum(Amount))

it is more complex then this but this is the main picture

NB: in sum i used the aggr function but still the totals are wrongs