How to select the correct value from a child node based on if condition.

Hi,

I am building an XML Publisher report on EXCEL Format using an rtf template.

The input XML looks like below :

        <G_CURR_CODE>

          <CURRENCY_CODE>GBP</CURRENCY_CODE>

          <LIST_G_GL_YEAR>

            <G_GL_YEAR>

              <GL_YEAR>2012</GL_YEAR>

              <LIST_G_SALES>

                <G_SALES>

                  <MON>Jan</MON>

                  <MM>01</MM>

                  <YYYYMM>201201</YYYYMM>

                  <MONYYYY>JAN-2012</MONYYYY>

                  <TOT_CURR_SALES>1034.67</TOT_CURR_SALES>

                  <TOT_SALES>1034.67</TOT_SALES>

                </G_SALES>

                <G_SALES>

                  <MON>Mar</MON>

                  <MM>03</MM>

                  <YYYYMM>201203</YYYYMM>

                  <MONYYYY>MAR-2012</MONYYYY>

                  <TOT_CURR_SALES>2723.82</TOT_CURR_SALES>

                  <TOT_SALES>2723.82</TOT_SALES>

                </G_SALES>

                <G_SALES>

                  <MON>May</MON>

                  <MM>05</MM>

                  <YYYYMM>201205</YYYYMM>