sub-categorizing columns of data

jorge_perez

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

txnelson

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.