My Query has below design:
CHAR1 and KFs Structure (Including 5 KFs) in ROWs; CHAR2 in Column.
aa bb cc
abc kf1 1 2 3
kf2 1 2 3
kf3 1 2 3
kf4 1 2 3
kf5 1 2
xyz kf1 1
As shown, at some places KFs have NULL values because Char1 and Char2 does not have posted data against each other. I want these NULL to be replaced with 0. I have tried +0 in all KFs, that did not work because we have one characteristics in rows and another in column. Please share any ideas.
I think you can't do it. It's about characteristic combination. You can have zero values whenever you have the combination on abc,xyz with aa,bb,cc values (this can be done with what you have done on the CKF add zero) otherwise you can't show zero values.
I haven't tried to make it as a workbook and change on the workbook settings the display non existing values to zero.