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!
