|
The data you've posted doesn't quite match up with the example you show. Where does "SOC" come from? Is it another category? However, here's something you can try:
1. Group by the "No." field.
2. Group by the Status field and set the sort order to descending.
3. If "SOC" is another category, you'll create formulas to summarize the numbers - something like this:
mailto:%7b@COCTotal - {@COCTotal }
If {table.Category} = 'COC' then {table.Total} else 0
4. Create a formula for the row total:
mailto:%7b@RowTotal - {@RowTotal }
Sum( mailto:%7b@COCTotal - {@COCTotal }, {table.Status}) + sum( mailto:%7b@SOCTotal - {@SOCTotal }, {table.Status})
5. The column totals for the COC and SOC columns are just the sum of the appropriate formula created in step 3.
6. The total column total is something like this:
mailto:%7b@GrandTotal - {@GrandTotal }
Sum( mailto:%7b@COCTotal - {@COCTotal }) + sum( mailto:%7b@SOCTotal - {@SOCTotal })
If this is a summary table at the beginning or end of a report that shows other data, you'll need to do this in a subreport.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|