CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Constant values in Pivot Table

edited Jul 4, 2014 5:00AM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered

I have an issue that I can't resolve.

I'm creating a combined analysis/pivot table where the customer wants to see (by Calendar Month/Year) the total number of Completed Activities, a count of Accounts with Completed Activities, and a count of ALL Accounts that are owned by a specific User. 

In the Calendar Month/Year prompt they want to be allowed to select as few one and as many as 10 values.

My problem is getting the total number of Accounts into my report.  If I include the Calendar Month/Year and the Nbr of Activities from the Activity object, my count only includes Accounts that have related Activities.  I can get the total number of Accounts in a separate Analysis without the Month/Year.  But I don't know how to merge each Account/Activity entry with the entry from Account.

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