You also have to calculate the percentage yourself, RS will not do it for you given the raw numbers.

How do you handle this process when you have unnamed parameters (ODBC uses the generic '?' for each parameter and you can't re-use a parameter in a query)?  MySQL only...

I do something like this:

select distinct User_Dim.Customer_Group_name as Customer_Group_Name,  User_Dim.Customer_Group_Name as label

from User_dim with (NOLOCK)

where not(Customer_Group_Name = '')

union

SELECT 'All' as ID, ' All' as Label

order by label

this gives me...

To format them, you need to click on the little green triangle in the upper right corner of the Total you created and you get access to sub-total properties where...