CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Suppress count except in total (pivot view)

edited Jun 13, 2014 2:13PM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center