Issue with using two expressions to create another expression in SQL server 2005
Posted on 2007-10-04
Hello. I am brand new to SQL server databases so please bear with me. I am using Visual Studio to create a report. I created my dataset and the report is working properly excluding the following...
The report contains two groups, Category and Subcategory. Both totals are based on the sum of "ContactTotal" field in my dataset. My issue is that I need to divide the number of each subcategory by the overall Category total. For example, the percentage of 'converter issue' would be 50% (50/100). The others would be 25%, however, I cannot create the expression being as both totals are based on the sum of the same field name. I guess in easier way to approach this issue would be to find out if there is a way I can re-name the calculated fields (ie CategoryTotal, SubCategoryTotal) so visual studio will recognize that I am trying to divide the Subcategory Total by the Category Total. Any assistance would be tremendously appreciated!
Category Total Subcategory Total % of contacts
Tech Issue 100
Converter Issue 50
No Dial Tone 25
Modem Offline 25