SQL Server Performance

Counting Customer Transactions

Discussion in 'Analysis Services/Data Warehousing' started by mattrigbye, May 21, 2007.

  1. mattrigbye New Member

    I have a question I'm hoping someone will be able to help me with - I've been working on it for a while and can't seem to find an obvious solution.

    Basically I have a fairly standard transaction fact table, and customers may have made multiple transactions over the selected range.

    I need to know how many customers made 1 order, 2 orders, 3 orders, etc. As far as I can tell, I'm effectively doing a count of a count.

    It seems to me to be a fairly straightforward request, however I can't work out a way to do it in Analysis Services. If someone can help me out or point me in the right direction I would be very grateful

    Thanks,
    Matt
  2. satya Moderator

Share This Page