CROSSTAB - Variable as Column Header?

[Former Member]

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.

[amitrathi239]

image is missing.variable is dimension or meansure?

[Former Member]

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

Image is posted.

[amitrathi239]

what is the formula of yes/no?

[Former Member]

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.

[amitrathi239 · Accepted solution]

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"

[Former Member · Accepted solution]

Thank you! I am not sure why it works (yet!) but it did. Thanks for your time and patience.