In XACT, create a new Variable.
Call this Variable "Volume" and make it per-cue-instance. Set the range from -96 to +6.
In XACT, create a new RPC.
Call this RPC "VolumeVariation."
Open this RPC, and select Volume as a variable, and make it drive the Sound Volume.
Change the curve to be at -96 dB when Volume is -96, and +6 when Volume is +6.
Now, right-click on your Sound, and select "Attach RPC" and select the VolumeVariation RPC.
When using this sound at runtime, you can call SetVariable() on the Cue to change the Volume according to your curve -- -96 dB up to +6 dB.