How to sum up result of a column and remove the users?

[haneeshmarella]

How do I sum up OFFLINE Ops at Rate result of each column and remove USER_NAME such that I get the number 3 (1+1+1) under OFFLINE Ops at Rate for Supervisor?

OFFLINE Ops at Rate is

IF(Count(DISTINCT IF(OFF_ON_LINE='OFF-LINE',CASE#))>=[OFF-LINE

Hours]*70,count(distinct IF(OFF_ON_LINE='OFF-LINE',USER_NAME)),0) for each USER_NAME name.

I used the below, but it gives a result of 0.

sum(aggr(IF(Count(DISTINCT IF(OFF_ON_LINE='OFF-LINE',CASE#))>=[OFF-LINE

Hours]*70,count(distinct IF(OFF_ON_LINE='OFF-LINE',USER_NAME)),0), USER_NAME,SUPERVISOR,DATE))

[haneeshmarella]

I meant 45 mins to reload the data and not correct the expression haha.

[sunny_talwar]

Well, if this is a static value which doesn't have to change based on selection (for example based on USER_NAME), then you perform this in script... other than that, if USER_NAME, SUPERVISOR, WeekStart come from the same table, you might be able to create a field which concatenate there value into one and then you might be able to use set analysis instead of using Aggr()...

but besides these two option, I don't think you can do much to get this resolved....