Aggregation Help

[haneeshmarella]

Week	Supervisor	Associate	Total Cartons	Total Pieces
02/04/2019 - 02/10/2019	AAA	A	1,123	7,701
02/04/2019 - 02/10/2019	AAA	B	167	758
02/04/2019 - 02/10/2019	AAA	C	1,208	9,369
02/04/2019 - 02/10/2019		D	1,265	5,345
02/04/2019 - 02/10/2019	BBB	E	1,019	5,127

Hi guys,

How do I get the total sum of Total Cartons and Total pieces for the week where supervisor is present? I use the following formula to get the numbers above

Total Cartons = Count (Distinct case#)

Total Pieces = Sum (Units#)

How do I aggregate such that the total sum for the week should include only where there is Supervisor name, if Supervisor is blank, the sum should not include the respective cartons or pieces numbers.

The result would be this without including numbers of blank supervisor cell

Week	Total Cartons	Total Pieces
02/04/2019 - 02/10/2019	3,517	22,955

Any help is highly appreciated!

[pradosh_thakur]

Total Cartons = Count (Total <Week> {<Supervisor={"*"}>}Distinct case#)

Total Pieces = Sum (Total <Week> {<Supervisor={"*"}>}Units#)

Try the above

[haneeshmarella]

Thanks for the response Pradosh.

When I filter it based on Supervisor, it gives a wrong total.

[pradosh_thakur]

what do you need when supervisor is selected ?

[haneeshmarella]

The total sum of carton/pieces for that supervisor.

[pradosh_thakur · Accepted solution]

Total Cartons = Count (Total <Week> {<Supervisor*={"*"}>}Distinct case#)

Total Pieces = Sum (Total <Week> {<Supervisor*={"*"}>}Units#)

[haneeshmarella]

Thank you, that works!