First the modern option. Use /CAE V6.6 (it's been out for more about a year now, so you should have it).
In the pressure dialog there is an option for "distribution". Next to it is a button "Create". Use the create and you'll get taken to an expression editor. Write your analytical expression for the field (in terms of global or local coordinates) using standard Python syntax. The dialog actually shows the valid operators. In any case, it should be pretty obvious... Things like sin(X/pi), pow(X,2)+pow(Y,2) and so on are all valid.
You'll notice that once you've created an Analytical Field, it will appear in the model tree (for further editing etc).
These Analytical Fields can be used on more loads/fields/BCs than just pressure. Whenever it is valid you'll see the "Distribution" option in the dialog box.
The other option, and no doubt old timers will write in as it being *the* solution

is to use the DLOAD user subroutine. Sure, you can do that too...