Skip to Content
avatar image
Former Member

CROSSTAB - Variable as Column Header?

A very simple Crosstab and I can't understand why I am getting the Multivalue error, ONLY with my variable but not with any fields directly from the Universe as the column, it works.

See the image.

data.png (13.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Former Member AMIT KUMAR

    I have made the variable a detail and dimension, not a measure as it isn't a number.

    Image is posted.

  • what is the formula of yes/no?

  • Former Member AMIT KUMAR

    The formula is an if statement. It looks at other columns that aren't relevant I think to this issue.

    Is looks something like this...

    =If([ColumnA]="TRUE";If([ColumnB]="TRUE";"YES"; If([ColumnD]="TRUE";If([ColumnB]="TRUE";"NO";"MAYBE"); If([ColumnW] = "TRUE";"NO";"MAYBE"))); If([ColumnG] = "TRUE";If([ColumnH]="TRUE";"YES";"NO");"MAYBE"))

    Maybe IF statements can't directly be used in Crosstabs? Another variable needs to be added? I have another crosstab where I convert a date in a variable and that works OK.

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 04, 2017 at 03:31 PM

    it's happening in cross tab because you are getting multiple results in variable for Team A.

    check you first table where For Team A you have two results (Yes and May be)

    If you remove the ID column in the table you will get the multi value there also. You can try to include ID with foreach context in the variable.

    e.g =If([ColumnA] foreach (ID)="TRUE"

    Add comment
    10|10000 characters needed characters exceeded