Pivot Table

[#1]

Hi,

I am using a pivot table as below;

Month	TransNo	Returns	Value
Jan 2012	ABC1	1	250
Feb 2012	ABC2	1	50
Feb2012	ABC3	1	100
Mar2012	ABC4	1	25

the value is being calculated by;

if([Returns]>0,(max(Aggr(sum(Value),TransNo))))

However when the columns are collapsed it shows the total value rather than the value for returns.

How it is:

Month	Returns	Value
Jan2012	1	1,000
Feb2012	2	2,000
Mar2012	1	1,500

How it should be:

Month	Returns	Value
Jan2012	1	250
Feb2012	2	150
Mar2012	1	25

If anyone could help me resolve this issue it would be much appreciated.

Thanks in advance!