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 |
