Link to home
Start Free TrialLog in
Avatar of IntercareSupport
IntercareSupport

asked on

Creating Drill downs in Cognos 8

The data is meant to show how many visits a provider has made during a certain period.  It needs to then be separated by location, and finally provide a total count by provider, and then by organization.

The screen shot shows the data I would like to display when the user clicks a particular location to drill down into, then finally again by provider.  I am wanting to establish visits by counting the "Patient_ID" field.

I don't know anything about Cognos and my brain is mush.  Help.

*Note--even though I have said I would like drill-downs, I'd settle for the data to just show location, provider, and then total visits.  My counts are currently way off.
experts.PNG
ASKER CERTIFIED SOLUTION
Avatar of welchb123
welchb123

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of IntercareSupport
IntercareSupport

ASKER

You rock.  This worked the very first time.  I greatly appreciate your help yet again.  I'd award more points if I could.