topic Re: sub-categorizing columns of data in Discussions

sub-categorizing columns of data

jorge_perez — Mon, 05 Mar 2018 16:15:52 GMT

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

Re: sub-categorizing columns of data

jorge_perez — Mon, 05 Mar 2018 16:19:53 GMT

Re: sub-categorizing columns of data

txnelson — Mon, 05 Mar 2018 20:37:29 GMT

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.

Re: sub-categorizing columns of data

jorge_perez — Mon, 05 Mar 2018 22:15:51 GMT

thanks.