Totals by Customer in Straight table

[Andrew_B]

Hi there

we are looking to determine the total stops (or group of deliveries), by a customer

this will be represented in a straight table

Fields are

dimensions  - CustomerID, StopDateId, DeliveryWeekday

Below are the columns and the formulas we were able to figure out

Customer ID    - dimension

DeliveryWeekday   - dimension 

Count of Stops for each weekday ( aggr(count( StopDateID), CustomerID,DeliveryWeekday))  - which is giving the same total 

the challenge is

Total count of stops by Customer

We attempted =sum ( aggr(count(  StopDateID), CustomerID)), however, this will only give us a value on 1 of the Delivery days

our goal is to have the total count on each delivery day

below is an image of the table  

Appreciate the help

[Lisa_P · Accepted solution]

Add in the NoDistinct qualifier before the Count

[Andrew_B]

Appreciate this

its perfect

Thanks for your help