aka_krakur
Active Member
- Joined
- Jan 31, 2006
- Messages
- 438
I run a query that brings back results with a particular column that I'm interested in breaking down even further.
It's a column that has data like this:
1485 - Failure; 1586 - Color; X100; 1785 - N/A
The one thing is that this column's data is never consistently the same size of data. It may only have like one(1) item (ie. X100). SO I can't break it down.
I ultimately would like to create pivot tables based off of the Top 10 failure codes. Right now I have to run a query for each top 10 failure modes. But it would be a lot more advantageous to run a complete query that pulls all data and then a formula somehow splits all these up and counts them and creates a pivot table.
It's a column that has data like this:
1485 - Failure; 1586 - Color; X100; 1785 - N/A
The one thing is that this column's data is never consistently the same size of data. It may only have like one(1) item (ie. X100). SO I can't break it down.
I ultimately would like to create pivot tables based off of the Top 10 failure codes. Right now I have to run a query for each top 10 failure modes. But it would be a lot more advantageous to run a complete query that pulls all data and then a formula somehow splits all these up and counts them and creates a pivot table.