Sum of values (weeks) with 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

[vinieme12]

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

[Sara_3]

I need the MAX value of Weeks then I need SUM of all values . Like 34, 23, 17 are MAX values of each status then I need to SUM of all Values . I tried Aggr functiom to SUM but  didn't work.

[vinieme12]

Please post some sample data that best represents that your actual dataset

try below

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