share in what if table

[#1]

hi all

I need your help in situation

I created a straight table and  sliders for using an what if; it contains for ex:

salesman   revenues     share                 what if revenues                what if rate          what if share

S1                   10               28.5%                      20                                200%                    44%

S2                   5                 14.2%                        5                                100%                    11%

S3                   20                57.1%                      20                               100%                     44%

Total              35                 100%                       45                                                             100%

what formula do I need to obtain share from what if corectly?

thanks