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.