Hello forum, I am attempting to modify an existing WebI report to split quality audit results for different types of interactions. Our server administrator has disabled free hand SQL and I can’t figure out how to get what I want.
The Dimension [Criteria Name] contains somewhere on the order of 30 different criteria built into our quality form. Each criteria has associated [AnswerText]
One of the criteria identifies the type of interaction which occurred. For clarity, I’ll just call them 1 and 2. Currently the report doesn’t differentiate scores for interaction 1 vs. interaction 2. I need to be able to do that.
I set out creating a variable like this:
=[Answer Text] Where ( [Criteria Name] = “1” ) ForAll([Criteria Name])
If I add this variable to the cross tab, in line with the rest of the results, everything looks fine. However, I want to create sections. If I try to create a section master using this variable, I get a #multivalue error in the section master cell.
How can I make it do what I want?
Thank you
chrismeu (BOB member since 2011-03-24)