Suppose I have the following evars, and recorded data:
Dimensions:
evar1 = Member_ID {A123, A422, B154, D481}
evar2 = Survey_Responses {85, 90, 91, 93, 65}
Month
Using Adobe's freeform table, this would appear as follows:
Default Tabular view:
| Occurrences |
Month | 85 | 90 | 91 | 93 |
Feb 2024 | | | | |
Member_ID | | | | |
A123 | 1 | 0 | 0 | 0 |
A422 | 0 | 0 | 1 | 0 |
B154 | 0 | 1 | 0 | 0 |
D481 | 0 | 0 | 0 | 1 |
However, I would instead like the values for the survey response evar to be condensed into one column, and each member's response be reflected in that column. So for example, it would look something like this:
| Occurrences |
Month | Evar2 (Survey Responses |
Feb 2024 | |
Member_ID | |
A123 | 85 |
A422 | 91 |
B154 | 90 |
D481 | 93 |
Is this possible in Adobe?