1 Reply Latest reply: Jan 9, 2017 4:23 AM by Marcus Sommer RSS

    Union between tables

    Max Goldshtein

      Hello

      I am trying to union 2 dimensions and count each value in each dimension, showing the counts in one table (as I understood it's possible to visualize it only in charts and pivot table).

       

      Here is the script I'm using:

      ----------------------------------------------------------------------------------------------

      Dimension:

      ValueList('Passed','Failed','B','N','?')

       

      Measure:

      If(

      ValueList('Passed','Failed','B','N','?')=

      'Passed',Count([Technical Validation]),

      if(ValueList('Passed','Failed','B','N','?')=

      'failed',Count([Technical Validation]),

      if(ValueList('Passed','Failed','B','N','?')=

      'B',Count(CalcBleed),

      if(ValueList('Passed','Failed','B','N','?')=

      'N',Count(CalcBleed),

      Count(CalcBleed)))))

      ---------------------------------------------------------------------------------------------

      'Passed','Failed' - 2 values in [Technical Validation] column

      'B','N','?' - 3 values in [CalcBleed] column


      What I get is a pivot table that counts for each value all the rows in the Data (1688): Attached image with pivot table of the calculation (union).

      Can someone help me with the script please?

      Thanks!