Hi All,
I am working on a report and got stuck on a requirement.
I have a cross tab report with an origin, Destination, scheduled depart date, actual depart date and 5 measures.
As per the above image, If Origin is DFW and airbill destination is IAH, we have the different shipments departing on the same date to the same location. We want to see for IAH what is the total shipment(Total pcs), total weight etc in one row instead of individual line shipment. So for IAH it should display 67+51+52=170 pcs and same for other measures.
Please assist me to achieve this.
Regards,
Abhishek
The first row has a different Manifest Actual Depart Date, but you're right it should total to 103.
Can you please show the Rows, Columns and Marks Card for this because there's something in the settings that are not correct.
