Getting Parent Node Value of a Child Node for use in a filter

[christopher_gaal]

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..

[MDXpressor]

Chris, I answered this in your other string.