I have a report where i'm trying to filter out the records in a group but the formula is not working

Selection Formula(Group) I have now in Group record filter is

ProcessDt in ProcessDt and SUM(CALCAMT) = SUM(RETAMT)

Data is below

I have grouping on PID

Scenario#1

Detail :ProcessDt PID TransID CALCAMT RETAMT DIFF
           5/25     1234   DU   1500    3000   
           5/25 1234    RC    0      3000              
           5/25   1234   DU    1500    3000

Data I wanna see on GF is below
GF          5/25   1234       $3000 $3000 $0     


Scenario#2

Detail :ProcessDt PID TransID CALCAMT RETAMT DIFF
           5/28     7658   DU     390      190   
           5/28 7658      RC    0     190              
           5/28   7658    DU     190    190
           5/28    7658   DU    0       190

Data I wanna see on GF is below
GF     5/28    7658        $190    $190    $0
      

Edited by Nav522 - 28 Jun 2018 at 8:20am