Transform Your Exported Reports into Insightful Pivot Views

 

In logistics and supply chain management, data is generated at every step — from shipment creation to delivery confirmation. The challenge is not collecting data, but making sense of it quickly. That’s where TrakIT’s export feature, combined with Excel’s Pivot Table capability, becomes a game-changer.

When you export a report from TrakIT, you receive a structured dataset, ready for in-depth analysis. By using custom-made, pre-designed Excel report templates having multi-dimensional Pivot Views, you can instantly turn that raw data into an interactive, visual summary that reveals trends, patterns, and opportunities. And when you need advanced, customised representations, our expert data modelling team can fulfil any of your multi-dimensional analysis requirements.

What is a Pivot View?

A Pivot View in Excel is more than just a summary table. It’s an interactive analytical dashboard that lets you:

• Slice your data by different dimensions (e.g., customer, route, month)
• Dice into specific details without writing a single formula
• Filter for quick scenario analysis
• Aggregate numbers instantly for high-level summaries

Think of it as the fastest way to turn a flat Excel export into a decision-making tool.

Why Pivot Tables are Perfect for Multi-Dimensional Logistics Analysis

In the logistics world, there’s rarely just one way to view performance. You may need to see the data:

• By Region → Service Type → Month to check seasonal demand
• By Customer → Route → Transit Time to identify bottlenecks
• By Depot → Shipment Type → Carrier to evaluate operational efficiency
• By Port Clerk → Shipment Allocated vs. Customs Released vs. Pending Release to measure clearance performance and identify process delays

With Pivot Tables, you can:

• Group & Summarise – For example, total shipments by region and month.
• Drill Down – Double-click to see the shipment details behind any summary figure.
• Filter Dynamically – Use slicers for quick “what-if” scenarios.
• Cross-Tabulate – Compare multiple dimensions side-by-side, such as cost vs transit time per route.

Why This Matters for TrakIT Users

Time is critical in logistics. The faster you can interpret data, the quicker you can act. With Pivot Views:

• Managers can track performance by multiple KPIs in one place.
• Operations Teams can identify recurring issues in specific lanes or carriers.
• Port Clerks can monitor and improve clearance efficiency by comparing shipments allocated, released by customs, and pending release status.
• Finance Teams can reconcile costs by customer or shipment type.

When your reporting needs go beyond standard exports, our expert data modelling team can design and deliver tailored multi-dimensional data views — or create pre-designed Excel templates — ensuring your analysis is fast, consistent, and perfectly aligned with your operational goals.

TrakIT gives you the data. Excel’s Pivot View turns it into actionable insights. With our custom-made pre-designed Excel templates and data modelling expertise, any of your multi-dimensional data representation needs — from operational insight to clearance tracking — can be delivered ready-to-use. 

The result? Faster insights, zero setup hassle, and decision-ready analytics that empower smarter, quicker decisions.

Connect with TrakIT Support now to set up your Pivot Table Templates.

Company-Based Service & Job Type Assignment

 A new feature has been introduced in TrakIT to allow services & job types to be assigned based on specific companies defined in the system.

With this update, services & job types can now be managed at the company level, enabling better control over which services & job types are available to which companies.

Key Details:

• All existing services & job types have been automatically enabled for all existing companies in the system to maintain continuity.
• Going forward, services & job types can be selectively enabled or disabled per company as needed.

Need Changes?

For any modifications to service or job type assignments, please contact TrakIT Support or your System Administrator.

Document Links in Query Reports

With the latest update of TrakIT, it is now possible to include hyperlinks in reports that allow users to download documents directly. The source of these documents can be work orders, finance documents, or any other relevant documents.

The document is rendered as a link that can be clicked on Excel or HTML reports. In CSV or text reports, the URL is included.

As an example, a report listing out all Invoices or Bills could also include a link for the Invoice or Bill document.

Please connect with TrakIT Support if you need to include document links in your report.

Changes to the Tax Layout

Based on user feedback, the layout of taxes on account line items has been changed. This applies to Invoices, Quotations and Bills.

Previously, an invoice would display taxes as a separate column for each applicable tax. For example, if there were 2 taxes applicable for different line items, these would be shown in two columns.

With the new layout, the tax columns have been re-organised, as shown below.

The Tax Name, Tax Amount and Total+Tax columns are not fixed to display the relevant content based on the tax type. If a line item has more than one tax, it will be shown as separate lines within the same column.

For any questions or concerns, please contact TrakIT Support.

Phantom Event/Data Issue

Issue Summary

On Thursday, the 27th of March, at 14:50 UTC, an update was rolled out to all TrakIT installations. This update caused an issue when work orders were reset. The problem caused some events and data fields in the work order to be replicated in other work orders where the same fields were empty. The issue was rectified, after which the extra events and data fields with incorrect values were cleared. No data was lost, and no other modules were affected.

The majority of TrakIT installations were not affected. Only those installations where one or more work orders were reset during this time were affected. If your installation was affected, our support team has been working with you to restore the affected data.

We want to sincerely apologize for this issue. We understand that this may have disrupted your workflow or affected your experience, and we deeply regret any inconvenience this may have caused.

Issue Details

An update was made to a stored procedure that resets a work order. This procedure is called when a work order is reset manually or when the workflow and/or services are changed. It can also be called with an action after an event or data field is changed. 

The Reset procedure performs five steps:

1. All events & data are copied into a temporary table.
2. Extra events & data are removed from the work order. In case of a workflow change, all events & data fields are removed.
3. Events & data that are missing are added to the work order. In case of workflow change, all events & data fields are added as per the workflow set-up based on the services selected, job type, and customer selection.
4. In case of workflow change, restore the temporary table into the event & data fields that match the code of the original fields.
5. Reset KPIs to match the workflow definition.

In step 4, an issue was identified that was preventing the restoration of events and data fields after the change of the workflow. The update issued on Thursday attempted to fix this issue. While the issue was fixed, events and data were also restored on other unrelated work orders on empty matching fields. It is important to note that only empty events and data fields were populated. No existing events or data were overwritten at any time.

Upon discovery of the issue, the cause was identified and fixed at about 09:30 UTC on the 28th of March. Subsequently, affected events & data rows were identified and cleared using available backups as a reference.

Root Cause

While the update to the stored procedure was tested extensively on work orders by changing workflows in test scenarios, the test cases only tested the work orders on which the updates were performed and failed to notice the full impact of the modified procedure.

Recurrence Prevention

Updates to stored procedures that involve bulk updates or insertions shall be verified against expected row counts. Expected run times shall also be measured and verified when testing stored procedures. A more careful impact analysis shall be performed on such updates.

Please be rest assured that we take this matter seriously. We work diligently to identify and resolve such problems, and we will implement measures to ensure that similar issues are prevented in the future.

We truly value your trust and patience as we strive to improve. If you have any concerns, questions, or feedback, please do not hesitate to reach out to us at support@trakit.in. Your insights are invaluable to us and help us serve you better.

Thank you for your understanding and continued support.

New Event/Data Filters for Advanced Report

With the latest update of TrakIT a new 'Event/Data Values' filter has been introduced for Advanced Reports. Previously, it was only possible to select either completed or not completed events/data fields as filters. Any other condition had to be added as a custom filter by the TrakIT Support team.

The new filter 'Event/Data Values' has replaced the previous 'Completed Event/Data' and 'Not Completed Event/Data' filters.

You can select one or more event/data codes. For example: DEL, ETA. If any of the event/data fields match the condition, the work order will be included in the report.

The values of the event/data field can be compared with a list of available options explained below:

• not empty/TBA - Value must be not empty or "TBA" (To Be Advised)
• NA - Value must be "NA"
• TBA - Value must be "TBA"
• empty - Value must be empty
• a date this month - Value must be a date that falls in the current month
• a date this quarter - Value must be a date that falls in the current quarter
• a date this year - Value must be a date that falls in the current year
• a date from - Value must be a date that falls on or after the specified date
• a date up to - Value must be a date that falls on or before the specified date
• a date between - Value must be a date that falls in between the specified dates (both dates inclusive)
• a date within last - Value must be a date within the last specified number of days
• a date within next - Value must be a date within the next specified number of days
• a partial match - Value must be a partial match for the specified text
• starting with - Value must begin with the specified text
• ending with - Value must end with the specified text
• an exact match - Value must be exactly the same as the specified text
• not containing - Value must not contain the specified text
• from list - Value must be exactly one of the items in the specified list of items (comma or semi-colon separated)
• a number >= - Value must be a number equal to or greater than the specified number
• a number <= - Value must be a number equal to or less than the specified number
• a number in range - Value must be a number in range of the specified numbers (both inclusive)

Please note that all text comparisons are case-insensitive. "ABC" is the same as "abc".

The 'Negate Condition' checkbox inverts the condition set for the filter. For example. If you have set the 'Ending with' filter, negating it becomes 'Not ending with'.

By default, the event/data filters only look for events and data in open work orders. To search within closed work orders, select the 'Include closed WO' checkbox. Note that this can cause the report generation to take a lot longer than it normally would. Do not use this option unless you really need it.

For any questions or clarification, please contact TrakIT Support.