Help: Group BY, AGGR, Join Temp Table in Script?

[#1]

Hi All,

I am trying to create a temporary table in the Script however i am a little unsure on the best way to go about this. I have attached an excel document that has soem exampel raw data and teh table i would like to create.

Any help would be appreciated.

thanks

dan

[Anonymous]

Hi,

See the file attached.

Regards,

Arjan

[#3]

Hi Arjan

Thanks for the reply. That looks like it does the trick.

Would it be possible to add a Field to  'DetailStart' called 'Secondreporter1011' and update this (where fy=2010/11) based on the expression 'count(SecondReporter)/count(FirstReporter)'?

Ultimatly what i would like to do is use the 2011/12 ratio as an estimate for 2010/11 as no historical data is available.

Thanks

dan

[#4]

Hi Arjan

Thanks for the reply. That looks like it does the trick.

Would it be possible to add a Field to  'DetailStart' called 'Secondreporter1011' and update this (where fy=2010/11) based on the expression 'count(SecondReporter)/count(FirstReporter)'?

Ultimatly what i would like to do is use the 2011/12 ratio as an estimate for 2010/11 as no historical data is available.

Thanks

dan

[#5]

HI Arjan

I think i have done what i am trying to do based on your above sample but it would be great if you could take a look and let me know if there is a better way.

Kind regards,

Dan