0 Replies Latest reply on Feb 13, 2020 5:32 AM by Marta Maldonado

    Creating multiple dimensions for a grouping dimension

    Marta Maldonado

      Hi all!!

       

      I've to analyze this sales data:

       

       

      Sales IdSales Detail IdSales Detail FamilySALES FAMILYImporteImporteImporteImporte total
      1ACristal

      Graduado

      5

      10

      30 EUROS

      50 EUROS

      1BCristal5
      1CMonturaGraduado2020
      1DLentilla

      Lentilla/PM

      1010

      20 EUROS

      1ELiquido1010

       

      And, for every sale (in this example with id 1), I've to determined multiple dimensions for the "sales family" (depending on the sales detail). So, as a result, in this example for the sales with id 1 I'd have:

      • 1 sale
      • 5 items sold (detail).
      • 3 sales family: graduado, graduado, lentilla/PM
      • 30 EUR for graduado family in the sale with id 1.
      • 20 EUR for lentilla/pm family in the sale with id 1.

       

      Then, is it possible to determine more than 1 dimension (graduado, lentilla/pm) for a grouping dimension (sale, id 1)?