Set Analysis with SUM and Max Function

[Sara_3]

The below is the sample data , when I select Customer it shows the one customer with multiple weeks fields , I need to SUM of weeks values in text box.

The Weeks field consist of :

Max({<[Category Type]={"ABC"},[Weeks]={">0"}>} [ Weeks])

Please help me how I put SUM function with the above Set Analysis to get  SUM of the values.

Output:

SUM of Weeks field in text box:

34 + 23 + 17 ===   74 

74 will be my desire output of this Customer.

Customer ID - Status	Weeks
101-01	34
101-02	23
101-03	17

[eronevil]

Does this help SUM(AGGR(Max({<[Category Type]={"ABC"},[Weeks]={">0"}>} [ Weeks])))?