Analytics Sort by Metro Name Summary then by Rank Listing
I have records in one table that contain metro names, id's and ranking from another table called 'Metros'. They are related by a metros foreign key.
I have an analytics layout that displays Metro Names from the 'Metros" Table Vertically and a MainTable::metro_summary which contains a Summary of metro id's from a foreign key field in the main table.
I need to be able to sort each metro but also sorted by a rank number that each metro id is associated with so the top will be metro number 1 then metro number 2 etc. The chart type is a horizontal bar.
Thanks again and any help would be appreciated.