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