Hello again you wonderful people,
I've got another report to create, I've pulled in the dataset (Survey Answers from a ClickDimension Survey) and I'm racking my brain how to get this right. Essentially we have a field called CDI_Question which will have values like "1. How old are you?" "2.Which City do you live in?" etc and the requirement is to have a new column for each question, with the CDI_Answer value underneath like so:
Ultimately we'd have one row for each of the surveys, with answers to each questions going along the columns.
Is there a way to filter a column without creating a new dataset for each (of the 29) questions? I thought about IIF but this didn't work, I can't seem to filter a row based on the content of the Question, just pull in all the answers to each.
As always, your help is greatly appreciated and I'm happy to share any other information you may need!
*This post is locked for comments
I have the same question (0)
