Select Content to Define an XBRL Footnote

Your Excel and Word objects might contain data or text that you want to use as an XBRL footnote. You can use CDM XBRL to select that content to define a footnote.

The content for the footnote must exist in the Excel and Word objects that you check out. You can add the footnote only to an intersection in the Pivot Grid that already contains a tag.

Note: When you add tags, you can create several tags at the same time and then save them. However, when you add footnotes, you must save each one individually.

To select content from a report object to define a footnote:

1. Open the project that you want to work with.
2. Open and check out the Excel or Word object.
3. In the Data Tools area on the ribbon, click Pivot Grid.
4. Above the Tag Inspector tab, click Pivot Grid.

   Tip: To simplify your tagging work, you can pivot or filter the Pivot Grid to approximate the appearance of the data in the Excel object. For example, you can change the Pivot Grid to move columns to rows, and rows to columns. If the Pivot Grid contains extra rows or columns that are not visible in your Excel object, you can filter them so that they are no longer visible in the Pivot Grid.

5. If the source of the footnote content is an Excel object, complete the following steps:
   1. In the Excel object, highlight the data that you want to use for the footnote. You can select only one cell.
   2. In the Pivot Grid, select the tagged intersection where you want to add the footnote. You can use Search to find the appropriate location.

      If the Excel data that you select contains the ##RS or ##XS variables, the table between that cell and the corresponding ##RE or ##XE from the Excel object is stored as escaped HTML as the content of the footnote. The same rules for text block tagging apply (column suppression, superscript, and so on). If the Excel data that you select does not contain the ##RS or ##XS variables, the content of the highlighted cell in the Excel object is converted to escaped HTML and stored as the content of the footnote.

      1. In the Excel object, highlight the data that you want to tag. The text block can be a section of data, or all data in the Excel object if necessary. If you want to select all the cells and contents between the ##RS and ##RE variables, select the cell that contains the ##RS variable. If you want to select all the cells and contents between the ##XS and ##XE variables, and also the cells on the same rows as the ##XS and ##XE variables, select the cell that contains the ##XS variable.

         Restrictions:

         • When using the ##XS and ##XE variable combinations in conjunction with a ##RS and ##RE range variable combination, the variables must follow this format:
           • The ##RS and ##XS variables must be placed in the same vertical column and the ##XE variable must also be in the same vertical column as ##RE.
           • You cannot have multiple ##RS and ##RE combinations on a sheet in an Excel object.
           • You can have multiple ##XS and ##XE combinations within a ##RS and ##RE combination, however, the ranges must not overlap.
         • When using the ##XS and ##XE variable combinations in conjunction with a print area, the variables must follow this format:
           • The ##XS variable must be in a column adjacent to the left edge and within a row of a print area.
           • The ##XE variable must be in a column adjacent to the right edge and within a row of a print area.
           • You can have multiple ##XS and ##XE combinations, however, the ranges must not overlap. You cannot place a ##XS or a ##XE variable within an area defined by an existing ##XS and ##XE combination.
         • When a ##RS and ##RE variable combination and print area both exist in the same Excel report object, only the ##RS and ##RE variable combination is considered and the print area is ignored.
      2. In the Pivot Grid, select the intersection where you want to create the text block for the data that you selected in the Excel object. You cannot select an intersection that is shaded gray.

         Important: You must select an intersection whose type is textBlock or escapedItem, or any type that extends any of these two. To find the type of an intersection, hover over its header, and view the type in the window that opens. Also, the concept's time period type must match the time period you are tagging against. If the selected concept has a period type of Instant, you must select an intersection with a time period of Instant.

6. If the source of the footnote content is a Word object, complete the following steps:
   1. In the Word object, highlight the content that you want to use for the footnote.
   2. In the Pivot Grid, select the tagged intersection where you want to add the footnote.
7. Click Home > Add Footnote, and click From Current. CDM XBRL creates a bookmark in the Excel or Word object, and links the selected text to the newly created footnote. The content of the footnote is displayed as a superscript in the Pivot Grid.
8. Click the Footnotes tab. The Footnotes tab contains details of your new footnote and any other footnotes in the Pivot Grid. When you click the number in the intersection, you can navigate to the footnote. When you click the More link in the footnote, you can see information about the footnote and you can navigate to the source intersection in the Pivot Grid. The footnotes that are shown in the panel are the footnotes that are related to all facts currently displayed in the Pivot Grid.
9. Click the Excel or Word object and save your changes.
10. Check in the report object.