VB.Net Sorting XML by ATTRIBUTE

I think have the vb.net xml transform code working right, just not doing well with the XSLT file.  My transform is copying the XML fine, just not sorting the TIER elements by RATE attribute.

I need an XSLT sort after my XML is built.  XML will have 1-10 products, products will have 1-50 tiers.

<RATES>
  <STATE ABBR="CA" NAME="California">
    <SUB1 CODE="001">
      <SUB2 NAME="sub2">
        <PRODUCT CODE="1234" TITLE="Product1">
          <TIER NUMBER="1" RATE="1.340" />
          <TIER NUMBER="2" RATE="5.080" />
        </PRODUCT>
        <PRODUCT CODE="4567" TITLE="Product2">
          <TIER NUMBER="1" RATE="1.340" />
          <TIER NUMBER="2" RATE="6.080" />
        </PRODUCT>
      </SUB2>
    </SUB1>
  </STATE>
</RATES>

Would like the above XML sorted as shown below.  In both cases, I'm sorting RATE in descending order to provide highest rate 1st.


RATE in TIER sorted with PRODUCT, PRODUCT retains orginal position
<RATES>
  <STATE ABBR="CA" NAME="California">
    <SUB1 CODE="001">
      <SUB2 NAME="sub2">
        <PRODUCT CODE="1234" TITLE="Product1">
          <TIER NUMBER="2" RATE="5.080" />
          <TIER NUMBER="1" RATE="1.340" />
        </PRODUCT>
        <PRODUCT CODE="4567" TITLE="Product2">
          <TIER NUMBER="2" RATE="6.080" />
          <TIER NUMBER="1" RATE="1.340" />
        </PRODUCT>
      </SUB2>
    </SUB1>
  </STATE>
</RATES>

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" >
    <xsl:template match="RATES">
        <xsl:copy>
            <xsl:apply-templates select="STATE">
                <xsl:sort select="TIER/@RATE" order="descending"  data-type="text"/>
            </xsl:apply-templates>
        </xsl:copy>
    </xsl:template>
    <xsl:template match="@* | node()">
        <xsl:copy>
            <xsl:apply-templates select="@* | node()"/>
        </xsl:copy>
    </xsl:template>
</xsl:stylesheet>

Select allOpen in new window