title: RunningCount webi Business Objects Formula
body: <p>I am trying to produce a running count of salesid's for each distinct customer id.</p>
  
  <p>I have tried this formula:</p>
  
  <p><code>=RunningCount([Order ID])ForAll([Query 1].[Brand Account ID])</code></p>
  
  <p>And unfortunately it yields this result:</p>
  
  <p><a href="https://i.stack.imgur.com/5ZdLw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5ZdLw.png" alt="enter image description here"></a></p>
  
  <p>We can see that where 'Count_of_Salesorder' == 12, it should have reset to 1 because the customer id has changed from B000115545 to B000159009</p>
  
  <p>How can I achieve the running count of 'Order ID' for each distinct customer id? (Customer id is the field containing values that begin with 'B000')</p>