After long time… 🙂
Well, I’m using Pivot view to show some column values across in cross tab. And, some other column in rows part of pivot.
For column and rows combination if measure value present in database it shows, if not it displays blank value (null).
You can’t suppress this null even by using ifnull(measure, 0)
Work around I found:
This will not show zero, instead strikethrough (-), which is acceptable and meaningful.
Here we go..!!
- Here is scenario based screenshot. Makred cells are null and no data in database for particular row & column combination values.
- Go to column properties > Conditional Format of measure column
- Add Action > Measure Column and add the following filter (isnull) as shown
- In Edit Format window, select and apply Strikethrough from the Effects option dropdown.
- Here is the result
Blanks are replaced with hyphen (–).