Trying to create a Pivot report for survey data (asmt_metric_result).
Each metric result has duplicate rows per question, so I need rows = assessment number, columns = questions, and cells = string_value (user response) instead it is showing actual value(number).
But Pivot tables only support numeric aggregations, not text/string fields, so string_value cannot appear in Pivot cells
Is there any alternative way to produce a matrix-style “question vs response” survey report?
Thanks!
