Suppress Drill Down in Pivot Table when Dimension is null

[malimohammed]

Hello Guys,

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.

Any help in this regard is highly appreciated. 

[Chanty4u]

is this qlikview or qliksense?

looks like qliksense

goto properties--Datahandling --un check include null values