Hi there am not sure it this is possable but i hope some one out there can help !!

What it is i have a flat report which only uses the detail section , with 2 graphs in the header section , the report i have has my company structure built into it , What i want is a formula that will use the level below in my company structure to the one that they are viewing

IE

COMPANY STRUCTURE

Company --> Directorate --> Business Unit --> L1

So if someone used the select expert to view the Directorate level the graphs woulds show the Business Unit Level, can you do this with the RECORDSELECT Function.

Before any One suggests a Drill Down Report Dont i Already have one Designed.