6 Replies Latest reply on Feb 21, 2018 6:41 AM by Olalekan Agboluaje

    Create Groups with over 1000 records and calculate measures

    Olalekan Agboluaje

      Hi All

      Like below, How do I put 2000 customer Nos into Group A, 5000 into Group B and 7000 into Group C and be able to calculate the sales per month as above?

      Group value will come form 10,000 customer numbers which is in this format( 001, 002, 003, 004…….). finding it difficult to create the groups let alone the calculations.

       

      It is easy to create a group with few Dimensions but not with hundreds or thousands of Dimension.

       

                                                                                                                      

       

       

       

                                                                                                                                      Sales per month

      Month/YearGroup AGroup BGroup C
      Jan-17ABCABCABC
      Feb-17ABCABCABC
      Mar-17ABCABCABC
      Apr-17ABCABCABC
      May-17ABCABCABC
      Jun-17ABCABCABC
      Jul-17ABCABCABC
      Aug-17ABCABCABC
      Sep-17ABCABCABC
      Oct-17ABCABCABC
      Nov-17ABCABCABC
      Dec-17ABCABCABC

       

      Thanks

       

      Ola