Subtitles of the Movie

In this video tutorial I'm going to show you how to Sort information when you're working with Tables and using Adobe FrameMaker 9. Consider the sample table seen here. This table shows the Marital Status of People Aged 15 Years and Older. There's a footnote inside the title, Marital Status of People and then a, indicating that this is the United States populace data. The table has a header with a gray background and inside the header we have categories such as Age, Total, whether the married spouse is present or absent and so on. On the left side of the screen we have the values represented as numbers in the thousands. On the right side of the screen we have the numbers as percentages. The total has a Footnote b, that tells us that the numbers are in thousands except for the percentages. We then have the information sort of By Age and there are two age groups that stand out. The age group 30 to 34 has Footnote c. This Footnote indicates that it's the control group. I also have a second set with Footnote d, this is my Target group and there's a yellow or a blue highlight. As the table gets sorted and the information is moved around you'll see that these Footnotes may automatically renumber because they reverse their order, or you may see that the yellow and the blue move around as the information is sorted differently. To get started, click anywhere inside a table and then choose Table, Sort. The Sort Table dialog allows you to select whether you want to Sort by Row, which is what I'm going to do and it's the default here, or by Column. Currently it's sorted by Age, but I'm going to change my sort to Total. I leave the rest with the defaults including the Ascending Sort and that the second and third categories are not sorting. I click the Sort button and the table reorganizes. You can see that the yellow highlight is now further away from the blue highlighted area and my Footnotes still read c and d. However, it's now sorted by the total numbers and therefore, in this bold category, you can see that we start at the 4.2 million and we end up down by the 22 and the 33 million. Again, I click anywhere inside the table, I'm going to do a different sort. I choose Table, Sort and this time I'm going to sort by Never Married. I scroll down till I find Never Married and select it and then click Sort. This time the two categories for the blue and the yellow have reversed themselves. The 35 to 39 has become Footnote c and it reads Target group at the bottom. D reads Control Group, so the blue and the yellow have reversed themselves and the Footnote numbering has automatically corrected itself. I'm going to change this back to the default, which was Age and you'll see that the c Target Group and d Control group revert. I choose Table, Sort, I scroll up to the beginning and select By Age and then click Sort. The two have reversed themselves: c for the Control group, d for the Target group. Rather than sorting by one of the numeric values I may also want to sort by percentage, so again, clicking anywhere in the table and choosing Table, Sort displays the dialog and this time I scroll down until I get to the Married Spouse Absent as a percentage. You can see in the background that the Married Spouse being Absent has a few categories where it's decimal 6 percent and a few where it's 1.2 percent, so there is going to be some repeated information and this is considered in the sort. When I click Sort the values are organized, my 6 appearing at the beginning and my 1.2 being grouped together here in the middle. This is organized by age of 55 to 64, 65 to 74 and 75 to 84. I can further clarify the results. Currently 55, 65, 75 is sorted in age order and Married Spouse Absent reads 1.2 for all of these settings. I also have 1.7 down into these age groups and there's a much more noticeable jump: ages 25 to 29, 45 to 49 and 85 plus. I'm going to further define the sort by choosing Table, Sort and this time not only sorting by one category, but instead adding in a second, which is Age. I'm going to leave it with the default of Ascending order and I click Sort. Within my 1.7 I start at 25, 45 and 85; within the 1.2 it's sorted by 55, 65, 75, so it's in ascending order. Once more, Table and Sort and I can reverse the Ascending into a Descending order. I click Sort and this time my 1.2 are organized before my 1.7, but my age groups of 75, 65, 55 are in descending order and the same with 85, 45 and 25. Finally, I'm going to reset the entire table back to its defaults by going in and choosing Table, Sort, selecting only Age, changing this value to None and in a moment when I sort you'll see the information reorganize, the blue and the yellow reposition itself and watch c and d where I have my Target group and Control group, c and d reverse themselves so that I now have Control group and Target group; all of my values are back to being sorted based on age.