Q&A BY TAG 'crosstab'

You must sign in to ask a question. If you do not have an account, you can register here

I do not have a finite number of values to include "cases" on to create new columns
answered 16-08-2021 11:08:24 -0400

I have scenario where the number unique values in the column (questionid) could keep getting larger. so I can't set up a static list of CASE conditions is there a way to dynamically take the column value for question id and put it across the top of t...

Answers: 2
Related to: How to Pivot and Unpivot views

Register pivot crosstab

pivot dynamically based on values?
answered 08-04-2021 02:21:52 -0400

Is there a way to dynamically create the headers for the pivot based on the values in the data? for example if I have a field that has a mapping type that can either be "sector" or "region" and then have a value by person. and end up with a cross tab t...

Answers: 7
Related to: How to Pivot and Unpivot views

pivot crosstab