Why is the dynamic text on data driven pages not displaying a value from the grid attribute table?

I finally figured it out. The problem was that the shapefile was joined with a table and therefore would not display any dynamic text.

I thought that a join wouldn't impact the dynamic text but apparently it does.

So assuming 'SApeelfinal' is defined in the setup and the dynamic text is Label_1

Any field in the DataDrivenPages index layer table can be used as dynamic text. Use the format:

<dyn type="page" property="Field_Name_Goes_Here"/>

<dyn type="page" property="Label_1"/>

So you could have different text boxes with the following dynamic text but only from SApeelfinal Table :

<dyn type="page" property="Label_1"/>
<dyn type="page" property="SUM_COL9"/>
<dyn type="page" property="SUM_COL10"/>
<dyn type="page" property="SUM_COL11"/>

If you want fields from another table, then you would need to use Python scripting.