I'm currently grouping my report like this:

1. SourceName
   2. SubidName --> Distinct Count Running Total

I want to add a new level of grouping called AOI that only applies to one name in the SourceName Group and have the running total reset on each change of the new group. Example:

1. SourceName
   2. SubidName
      3. AOI (IF SourceName = "DRP" AND AOI="Healthcare")

Is this possible?

-Neal

Edited by npatel - 20 Jan 2011 at 10:24am