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
