1 Reply Latest reply on Jul 28, 2016 12:38 PM by emma.villarreal

    How to group by or count from a calculate field

    emma.villarreal

      Hi sorry to bother again, but I have a table with a calculate field with this instruction: COUNT([Cliente Id]) so I can see how many orders a client did year by year as u can see in the image I attach but how can I group how many people did 1 order, how many did 2 orders and how many did more than 3 orders ??? I want now another table with the year and how many people did 1 orders that year how many did 2 orders and like that

      Screen Shot 2016-07-28 at 11.09.00 AM.png