Suppress count except in total (pivot view)
I am running a report on the service request object and need to calculate the different type of SR's in the current week along with their Age in hours and total number of records for each type.
I have all the filters in place and correct data shows up too in a Pivot Table view.
I have 2 problems:
- I have put the "# of SR" metrics field in the Measures area. It gives me count as 1 for each row and I have done a summary by Type which displays the total at the bottom of each type.
I want to suppress the values for each row and only display the total at the bottom of each summation. Is this doable? except for making the text the same color as the background and trying to hide it?