Hi, wonder if anyone can help me? I need to create a single WebI variable for defining a 4-column structure in a cross-tab table.
The challenge is that some of the data needs to appear in more than 1 column: columns 3 and 4 provide the breakdown of column 1.
So, using elseif (as below) shows nothing in columns 3 and 4 as the data has already been shown in column 1.
= If [Dimension 1] = "Z002" Then "Column 1" elseif [Dimension 1] = "Z003" Then "Column 2" elseif ([Dimension 1] = "Z002" And [Dimension 2] = "ZA" ) Then "Column 3" elseif ([Dimension 1] = "Z002" And [Dimension 2] = "ZB" ) Then "Column 4" else "Other"
Is there a function other than 'Else' that would enable me to report data more than once? I've tried to use 'Or' instead of the 2nd elseif but this results in an invalid datatype error when creating the variable 😔
I've lived with a workaround of putting the repeated data from columns 3 and 4 in a different table, but this is getting messy and difficult to maintain, so I really need to find a solution with a single variable.
Any help much appreciated.
Patrick