Skip to Content
0
Former Member
Feb 17, 2009 at 10:40 AM

Reporting on a Hierarchy

32 Views

I want to create a query on a hierachy and filter based on that Hierarchy.

I want to include a specific node of that hierachy and then exclude a lower level node of the one I've just added. But I still want to include the lower level node I've just excluded but seperate from it's parent node.

The example I have is reporting on Data for an org unit. In this case for our Childrens Services org unit. I want to report on Childrens Services but exclude one of it's child nodes Schools. I then want in the same query to seperately report on Schools - the child node.

I want it to look something like this:

Amount

Childrens Services...........10.......

Schools..........................5.........

In the example the amount for Childrens Services does not include a value for Schools even though this is an org unit that is a sub node (e.g. part of) of Childrens Services.

Any ideas?