Hello. I've been searching all over the web and cannot find anything specific to my issue. What i'm trying to do is create a report that shows total units being shipped from one place to another as well as the % of total units. I have the report working fine from a units standpoint, but i want to express the values as the % of total units. for example, lets say i have two warehouse WA and WB, and 3 destintation X, Y, Z. I want to show the number of units for all the pairs (WA-X, WA-Y,..., WB-Z). i also want to express thes values as a percentage. sum(WA-X)/sum(WA). this would tell me what % of units that were shipped out of WA, went to X. in order to do this, i need to have sum(WA) already cacluated, so a running total wouldn't do the trick. Is there way for me to pull a value from one group and use it in another.

The source of my data is a sql server relational db.

thanks

howie