5 Replies Latest reply on Jun 19, 2018 2:34 PM by Soham Wadekar

    Use an aggregate result as a dimension?

    Jim Davison

      My apologies if this is answered, at a quick search I didn't find a comparable result:

       

      I'll use Superstore as an example, taking the "orders" table. I want to take an order count by customer (their number of of orders) to produce a frequency table that shows how many customer had that number of orders with an expected results something like this:

       

      Customers with N Orders:

      1 order : 5,432

      2 orders : 1,125

      3 orders : 567

      ...

      etc.

       

      Thanks!