Suppress Drill Down in Pivot Table when Dimension is null
I need to suppress dimension drill down when the child dimensions are null. I have created hierarchal data for project tasks some parent tasks have up to 5 children and some of them have 1-2 levels. I want to calculate the cost till the lowest level i.e; only if the child task exists.
Below is the image of the pivot table. In the below snapshot 1086 is the project number- General Requirements (Task-L1)-Sponsor (Task L2). I want to eliminate the null values under Sponsor (Task-L2) as there are no further tasks under it.