Report needs to show nulls

Regular Visitor

1 year ago

Hi, data is somewhat like this within the matrix.
The underlying data has rows of data that account for the 'count column' and then there is a lookup that provides the category and sub category and Rank to create the matrix view

Rank	Category	Subcategory	Count of coverage items
1	Category 1	Subcategory 1
1		Subcategory 2	12
1		Subcategory 3
1		Subcategory 4
1		Subcategory 5
2	Category 2	Subcategory 6
2		Subcategory 7	135
2		Subcategory 8
2		Subcategory 9
2		Subcategory 10	39
3	Category 3	Subcategory 11	816
3		Subcategory 12	314
3		Subcategory 13	34
3		Subcategory 14	63
3		Subcategory 15
4	Category 4	Subcategory 16	44
4		Subcategory 17	28
4		Subcategory 18	788
4		Subcategory 19	17
5	Category 5	Subcategory 20	56
5		Subcategory 21	634
5		Subcategory 22	13
5		Subcategory 23
6	Category 6	Subcategory 24	17
6		Subcategory 25
6		Subcategory 26	3
6		Subcategory 27
6		Subcategory 28	3
6		Subcategory 29	447
7	Category 7	Subcategory 30
7		Subcategory 31	99
7		Subcategory 32	29
8	Category 8	Subcategory 33	118
8		Subcategory 34	454
8		Subcategory 35
8		Subcategory 36	43
9	Category 9	Subcategory 37
9		Subcategory 38	596
9		Subcategory 39	78
9		Subcategory 40	4359
10	Category 10	Subcategory 41
10		Subcategory 42	2
10		Subcategory 43	2
10		Subcategory 44	10

Forum Discussion

Related content

Counting nulls

Handling Null Values

Replace Values Null to Blank or Blank to Null

Replace NULL

Null value error