Discussions
Remove % from Total of Column
I would like to know how to stop a Saved Search from totalling the Sum of percentages. The results of a search showing the hours worked and % of total available to work in a month are listed in 3 columns:
Sales Rep Hours Worked % of Total
William 102.25 58.9915%
Craig 88.5 51.0587%
Simon 60 34.6161%
Christian 58.6 33.8083%
Neale 3.75 2.1635%
Benjamin 1 0.5769%
Total 314.1 181.2150%
Sales Rep column is Grouped. Hours Worked and % of Total are Summed.
I want the total hours worked, but not a sum of the % column. Any ideas on how to remove this?