Suppressing second dimension when null

[Arthur_Fong]

Hi all,

Is there a way that I can suppress the null value for the second dimension in a pivot table, but first dimension still remains? 

Sample table is located below:

load DD1,IF(LEN(DD2)<1,NULL(),DD2)AS DD2,Value inline [
DD1,DD2,Value
A,A1,100
B,,200
];

What I would want to achieve is to get a pivot table that shows:

Since B has no DD2, it should not show anything(including null) in the second dimension.
If I uncheck the null value for second dimension in pivot table properties, this will not show the value for B.

Any workaround for this?

Thanks and regards,
Arthur Fong