Hi All
I think I need to use a Crosstab for this but I can't seem to work it out
Current Layout
Required Layout
I'm sure it is easy. Any help would be great
Thanks
Yes, that's exactly how you could achieve that. Easiest is probably the Tile tool. You can mark your unique field as Material - this will give you a Tile_Num and Tile_SequenceNum field - the Tile_SequenceNum field is the one you'll want to use that shows you the identifier per Material. Use that field to create your "Use #" headers, followed by the Cross-Tab.
See attached!
NJ
See attached, I think this will get you what you are looking for (though slightly different format than how you've displayed above). I'm assuming that what you want is the different uses across the top, and than an indicator of whether or not that material is needed for that use case. So in my example results, it's showing a count of 1 for every use, rather than the 1 2 3 that you are showing (since 1 2 3 would be your column headers instead).
1. Summarize by Material & Use, then count Use
2. Crosstab with Group by Material, Use as column headers, and Count as values.
Let me know if this gets you what you need!
Cheers,
Hi Nicole
Thanks for the reply but in fact I do need the numbers stated in the table (1,2,3 etc) across from the material.
