Calculating a number of all data but limited to values specific for the dimension
I've been trying all day to calculate a KPI, but without succes. If anybody can help...
I work for a transport company and need to calculate per customer how many units we deliver at the addresses were we deliver for this customer, regardless whether these units are sent by the same customer.
An example: At a certain moment customer A asks us to deliver 1 unit at address X and 2 at address Y. At the same time another customer B also asks us to deliver 1 unit at address X.
So for customer A we need to make 2 stops and during those 2 stops we delivered 4 units (3 from him and one from another customer)
So our 'number of units per stop' for this customer is 2 (4 units / 2 stops)