|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|
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!