10 Replies Latest reply: Nov 23, 2009 3:43 PM by DANIEL CHOTZEN RSS

    count by distinct customer and summed value by date

      My brain isnt working today

      I have a transaction table with customer id transaction date and transaction value. Customers may make multiple transaction per day.

      I have a pivot table with transaction date as dimension and sum(value) and count(distinct customer id) as expressions

      That all works fine, but what I need is another column with count of distinct customer id of customers spending more than £50 per day. Everything I try bring back junk.

      e.g.

      Date Total Order Value Total Customers Total Customers > £50

      [TXDate] sum(TXValue) count(distinct Customerid) ??????

      1/1/2009 £1223 123 12

       

      I'm sure its easy, just can't sus it

      Thanks