Objective:
- View billed amounts by practice area in relation to total revenue
Environment:
- Clio Manage
- Excel
Additional Information:
- The equation in step 11 should be similar to =SUM(Table1[[#Totals],[Billed Time]]/566390.7) (the divisor being your own Billed Time total)
Procedure:
- Go to Reports
- Select the Revenue Report
- Make any necessary selections (ensure that All is selected for Practice Area)
- Select CSV for the Output Format
- Click Generate Report
- Open the Report in Excel
- Select Insert > Table
- Leave "My table has headers" checked and click OK
- Right-click anywhere in the table and choose Table > Totals row
- Click into the Totals row under Billed Time and select Sum from the dropdown arrow
- Click into the row just below the Billed Time total; you will be creating an equation to divide the Billed Time total by the actual number in that field:
- Type =SUM(
- Click on the Billed Time total
- Type /
- Type in the number for the Billed Time total (do not click into the box above for this)
- Type )
- Hit Enter
- Right-click into the field with the equation and select Format Cells > Percentage
- Click on the drop down arrow in the Practice Area column and select an area. You can do this by checking the box to the left of the Practice Area you want shown.