Agg function

[New-here1]

Hi, 

Using the below, I get the correct result in the column, in the pivot table however, it is only showing the result in one column rather than all the columns. If this can be done then please help as I am a little stuck. 

Thank you

if(GetSelectedCount(Date)>0 and fabs(Num(Sum({<Date={"$(=max(Date))"}>}mydata),'#,##0.00000000')
- Num(Sum({<Date={"$(=min(Date))"}>}mydata),'#,##0.00000000'))>=5.00,
Aggr(Num(Sum({<Date={"$(=max(Date))"}>}mydata),'#,##0.00000000')
- Num(Sum({<Date={"$(=min(Date))"}>}mydata),'#,##0.00000000',0.001), [Name], [Type], Owner), null())

[rwunderlich]

Aggr is by default DISTINCT. Try adding the NODISTINCT keyword to your Aggr

Aggr(NODISTINCT...

-Rob