Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Compliance | CAT | |||
TOTAL | CAT-1 | CAT-2 | CAT-3 | |
TOTAL | 10 | 3 | 4 | 3 |
Approved | 5 | --- | 4 | 1 |
Not Approved | 3 | 2 | --- | 1 |
Not Applicable | 2 | 1 | --- | 1 |
Above is a Pivot table where
1- Compliance is Dimension -(ROW)
2- CAT is Dimension-(Column)
3-Count of Compliance is the measure
How can I eliminate the (--) for null and replace with ('0") Zero instead in my Pivot table.
Regards,
Srinivas
You can't. That -- is most likely missing data instead of nulls. It does not exist and therefore can't be replaced. You will have to add that during the load for the missing combinations of Compliance and CAT.