Value Of A Field In Determined Line

Hi, people! I'm a Brazilian and forgive me for my poor English...



I have a stored procedure in SQL Server 2000 with return me the follow data:



REGION | TYPE | VALUE_TOT

Reg 1 | TP 1 | 10

Reg 1 | TP 2 | 15

Reg 1 | TP 3 | 20

Reg 2 | TP 1 | 8

Reg 2 | TP 2 | 27

Reg 2 | TP 3 | 11

Reg 3 | TP 1 | 3

Reg 3 | TP 2 | 6

Reg 3 | TP 3 | 50



In the Reporting Services I make a grouping for REGION AND TYPE, and return me this:



REGION TYPE VALUE_TOT

Reg 1

TP 1 10

TP 2 15

TP 3 20

Reg 2

TP 1 8

TP 2 27

TP 3 11

I need place a new column in the right and a value only in the line where TYPE = TP 2. The value is: (VALUE_TOT in TP 2 * 100) / VALUE_TOT in TP 1.



It would be something thus:



REGION TYPE VALUE_TOT CALC

TP 1 10

TP 2 15 150

TP 3 20

Reg 2

TP 1 8

TP 2 27 337,5

TP 3 11



This is detail line, as would make this calculation? How it would capture the value of TP 1 and TP 2? Row number? Somebody has some idea?



Thanks! The MSDN in my language is little, have only 200 posts...