Hi,
I have a report which splits our contracts by a dimension. So I have the dimension called 'division code' (showing divisions within a range) then nested within that are all the projects with that division code. However I want to exclude any divisions that have no contracts
It sounds like you'll need to build a few NL("Filters") to restrict the results.
1st Filter to retrieve all contracts based on whatever filter criteria is appropriate. 2nd Filter to retrieve all the Projects based on the contracts returned in Filter 1. Then a 3rd Filter to retrieve all Division Codes based on the projects returned in Filter 2.
Something like this...
