When creating queries for a data warehouse, you may need to calculate what percentage of each customers portion is to the total. This can show you what percentage of total sales each customer makes up.
When creating queries for a data warehouse, you may need to calculate what percentage of each customers portion is to the total. This can show you what percentage of total sales each customer makes up.
Jim Salasek's SQL Server Blog 