All:
I have a requirement to produce a report that is targeted at one level of our organization structure (Level 4). But the report requirements have 3 sections:
Section 1
Level 3 total sales, one column
Section 2
Level 4 sales of the specificied (via parm) L4 value, as well as columns for all the other L4 values which are under L4's L3 parent
Section 3
Level 5 sales for each L5 value under the specified L4
So the question is how to pass in a specific level 4 value, and determine its parent level 3 value, so I can get a total on Section 1, a series of totals for both Section 2 and 3.
Chris..
Chris, I answered this in your other string.