- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
sub-categorizing columns of data
Hi, 'I am trying to find a way to subdivide the columns into different groups but allowing them to be in multiple gropus at the same time or being able to filter them easily. Lets say I have multiple suppliers for steel and aluminum and i want to be able to analyze only certain suppliers or i want to analysze all the parts made with steel no matter who the supplier is or by process. this would be used for a much much larger number of suppliers and products.
Thanks
supplier 1 | supplier 2 | |||||||
steel | aluminum | steel | aluminum | |||||
die casting | stamping | die casting | stamping | die casting | stamping | die casting | stamping | |
1 | ||||||||
2 | ||||||||
3 | ||||||||
4 | ||||||||
5 |
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: sub-categorizing columns of data
You can use a Data Filter, or a Local Data Filter to do the subsetting you are referencing. And if necessary, you can easily create a new column which is a concatenation of the multiple columns, and then use a Data Filter or a Local Data Filter to subset into whatever combination of selections.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: sub-categorizing columns of data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: sub-categorizing columns of data
You can use a Data Filter, or a Local Data Filter to do the subsetting you are referencing. And if necessary, you can easily create a new column which is a concatenation of the multiple columns, and then use a Data Filter or a Local Data Filter to subset into whatever combination of selections.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content