I implemented your solution it seems working fine except small problem , in 
one of the group the actual group count is 30 but the group count is showing 
only 20, is there any other things we need to do for this?

"xslspy" wrote:

> Its working like Champ.. :) thanks lot for the quick solution.The only other 
> thing i am struck with is dynamic display of group total , group average and 
> grand total.can you please help me in building this?
> 
> "Oleg Tkachenko [MVP]" wrote:
> 
> > xslspy wrote:
> > > the out put should be like this ...
> > > Roger Bos (sAssignedUser value from Table1)  - 10 (GroupCount Value from 
> > > Table 2)
> > > display sAssignedUser value from Table1 and the corrsponding GroupCount 
> > > value from Table2
> > > 
> > > Roger Bos   -     10 
> > 
> > Something like
> > <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
> > version="1.0">
> >      <xsl:template match="NewDataSet">
> >          <xsl:for-each select="Table">
> >              <xsl:value-of select="sAssignedUser"/> - <xsl:value-of 
> > select="../Table2[GroupVal = current()/sAssignedUser]/GroupCount" /> 
> > 
> >          </xsl:for-each>
> >      </xsl:template>
> > </xsl:stylesheet>
> > 
> > 
> > 
> > -- 
> > Oleg Tkachenko [XML MVP, MCAD]
> > http://www.XmlLab.Net | http://www.XLinq.Net | http://blog.tkachenko.com
> >