To make sorting easier, MEX allows its users to easily Group by Columns. Take your Work Order Listing for example, some of you would have a large set of work orders listed in your MEX system. By using the Group by Columns function you can further filter the listing to only show the relevant WO’s according to a defined search term within a certain column (e.g. Department = Electrical).
In comparison to filtering with Ranges, Grouping by Columns filters are easier to clear allowing you to always know when one is being used, helping to make working with your listings easier and less confusing.
To use the group by header, do the following:
Adding group column headers in MEX is a simple process.
This is the box shown for MEX 15
This is the box shown for both MEX 12 and MEX 14
This menu is shown whenever you right click on a column header in MEX 12
That’s pretty much it. You’re on your way to Grouping by Columns.
Here are some examples where the group by box would be useful (They look the same in MEX 12 and MEX 14, so if a screenshot is of a different system it will still look the same on yours). If you have multiple departments in your company that you raise work orders for you could group by department to get something like this returned.
Notice how the totals are also broken down into the groupings.
Or maybe you have a few stores in your facility and you use the MEX stores module. If you had many items you could make it easier to find them by grouping them by key fields.
Using this method it is now much easier to find catalogue items.
The group by box can be a very useful tool and allows you to select any column to sort by, choose the one that is right for your usage and it can clean up your listings and make them very easy to navigate.
Contact MEX Support at email@example.com for more information or call +617 3392 4777
Check Out Last Months Tech Tip on Missing Work Orders