3 Replies Latest reply: Nov 7, 2016 6:59 AM by Андрей Шепель RSS

    Ignore aggr in dimension

    Андрей Шепель

      Good day!

      i have one simple source table, which i load to QV

       

      Field1Field2Value
      Name1Value11
      Name1Value21
      Name2Value11
      Name2Value21
      Name2Value31
      Name2Value41
      Name2Value51
      Name2Value61
      Name2Value71
      Name3Value11
      Name3Value21
      Name3Value31
      Name3Value41

       

      In QV i created pivot with such order of dimensions: Field1, Field2 and there calculate sum(Value).\

      Following result:

       

       

      Field1Field2sum(Value)
      Name1Value11
      Name1Value21
      Name2Value11
      Name2Value21
      Name2Value31
      Name2Value41
      Name2Value51
      Name2Value61
      Name2Value71
      Name3Value11
      Name3Value21
      Name3Value31
      Name3Value41

       

      My necessary result - for each Field1 Show all values of Field2 (even if they haven't any value for some Field2 in source table).

       

      Field1Field2sum(Value)
      Name1Value11
      Name1Value21
      Name1Value30
      Name1Value40
      Name1Value50
      Name1Value60
      Name1Value70
      Name2Value11
      Name2Value21
      Name2Value31
      Name2Value41
      Name2Value51
      Name2Value61
      Name2Value71
      Name3Value11
      Name3Value21
      Name3Value31
      Name3Value41
      Name3Value50
      Name3Value60
      Name3Value70

       

      This task i must implement without changing load script and changing order of dimensions.

       

      Very glad for help!