AQX allows you to not only rank columns but to also rank different rows levels and different sections within the report allowing for much more flexible ranking than has been available before.
An outline of the different types of ranking are listed below.
If you want to rank a column:
- Right click on the column header - this will bring up a menu
- select Rank this Column.
This will rank a column in descending order of value. (i.e. Highest to lowest); will bold the column and row level it is ranking AND will show a rank number in the rows.
 |
If you want to rank the column in ascending order of value (i.e. lowest to highest) see 'Swapping between Descending & Ascending order' below |
If you want to rank items within a specified row level on the report layout you can. This is an extension of the 'Rank items within Parent' option that was in previous Landsberry & James software. However this new functionality allows for more flexible ranking at any row level.
For example: you may have Beer and Wine categories broken down by Advertiser in your rows. If you want to rank the top advertiser's within Beer and the top advertiser's within Wine keeping Beer and Wine in order, you can using Rank this level.
To Rank at a specific row level:
- Right click over the row level you wish to rank
- Select Rank this level
This will automatically rank the first column at that report at the specified row level. This column will be ranked in
- descending order of value. (i.e. Highest to lowest);
- will bold the column and row level it is ranking AND
- will show a rank number in the rows.
If you want a different column to be ranked, all you need to do is right click on the header of the column you wish to rank and select Rank this column. It will keep the specified row rank and rank the new column according to that.
|
If you want to rank the column in ascending order of value (i.e. lowest to highest) see 'Swapping between Descending & Ascending order' below |
Keep original order and place rank number in the rows
If you would like to keep the original order of your report and show the rank number beside the item ranked
- Right Click over the header of the column you wish to rank
- Select Rank this Column
- Right click over the header of the column you wish to rank again
- Select Reorder Ranked Rows
Example shown below.
Rank a Specific section of a report only
If you have more than one section in your report (identified by different colour backgrounds in your rows/columns) you can rank a specified section and leave the rest of the report in it's original order.
To rank a specific section
- Right click over the section and row level you wish to rank
- Select Rank this Level
This will rank the first column for ONLY that section leaving the other section in it's original order.
|
TIP: If you want to rank a column other than the first column for that section - right click anywhere in the column within that section and select Rank This Column. If you right click on the column header as before - it will rank the entire column and all sections. |
For example:
Swapping between Descending & Ascending order
Your initial rank will always select descending order (i.e highest to lowest). Should you need ascending order (i.e. lowest to highest) :
- Right click over the header of the column you have already ranked
- Select Descending Rank
This will change it from descending to ascending rank. If you need to take it back to descending rank - repeat the steps above
To clear all ranking all you need to do is
- Right click anywhere in your report
- Select Clear All Ranking