Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Multiple Groups in Matrix using the same column
02-22-2024
05:53 AM
I am tring to creat a matrix that holds groups from the same column with different combination.
SourceTable
Group | Type |
1 | A |
2 | B |
3 | A |
Then add them to a matrix row , the type to the column, and a value that counts.
OutPutMatrix
Group | A | B |
Group 1 | 1 | |
Group 2 | 1 | |
Group 3 | 1 | |
Group 1 & 3 | 2 | 0 |
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2024
06:35 AM

@CEllis , You have Create a new table
Group , Group Name
1 , Group 1
2 , Group 2
3 , Group 3
1 , Group 1 & 3
3, Group 1 & 3
Join it with the Source table group and use it in the visual
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2024
06:35 AM

@CEllis , You have Create a new table
Group , Group Name
1 , Group 1
2 , Group 2
3 , Group 3
1 , Group 1 & 3
3, Group 1 & 3
Join it with the Source table group and use it in the visual

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
07-29-2024 03:00 PM | |||
05-02-2024 04:01 AM | |||
05-24-2024 05:52 AM | |||
04-25-2024 07:02 AM | |||
Anonymous
| 01-19-2024 12:24 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |