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?