cancel
Showing results for 
Search instead for 
Did you mean: 

Showing Null values in Cross-tabs

Former Member
0 Kudos

Post Author: merv

CA Forum: Charts and Graphs

I've created a cross-tab report but I will like for the report to list the rows will null values as well as the rows with values. I need to do this because I cannot create one cross-tab with all of the necessary fields, so Iu2019ve created 3 cross-tabs and placed them side by side. Or is it possible to link the cross-tabs. Thanks

I would like to see the following

Total

A

A-

A+

B

B-

B+

C

C-

C+

D

Total-1

Total-2

Canada

MATH30800

24

12

0

0

4

0

4

0

0

0

0

Canada

MATH30800

24

Canada

MATH30800

0

Nigeria

MATH201

12

8

2

2

0

0

0

0

0

0

0

Nigeria

MATH201

0

Nigeria

MATH201

12

Poland

CHEM31800

8

0

1

0

0

0

3

1

0

0

0

Poland

CHEM31800

8

Poland

CHEM31800

8

Puerto Rico

MATH190

0

0

0

0

0

0

0

0

0

0

0

Puerto Rico

MATH190

1

Puerto Rico

MATH190

0

Panama

ENGR10300

39

3

4

1

2

4

6

3

3

0

1

Panama

ENGR10300

0

Panama

ENGR10300

39

Romania

MATH31601

4

2

1

0

0

0

0

0

0

0

0

Romania

MATH31601

4

Romania

MATH31601

0

Afghanistan

EAS10600

11

0

4

0

0

1

1

1

0

0

0

Afghanistan

EAS10600

0

Afghanistan

EAS10600

11

Bahamas

HS-COURSE

0

0

0

0

0

0

0

0

0

0

0

Bahamas

HS-COURSE

27

Bahamas

HS-COURSE

0

Brazil

HS-COURSE_2

1

0

0

0

0

0

1

0

0

0

0

Brazil

HS-COURSE_2

0

Brazil

HS-COURSE_2

1

instead of what's bellow

Total

A

A-

A+

B

B-

B+

C

C-

C+

D

Total-1

Total-2

Canada

MATH30800

24

12

0

0

4

0

4

0

0

0

0

Canada

MATH30800

24

Nigeria

MATH201

12

Nigeria

MATH201

12

8

2

2

0

0

0

0

0

0

0

Poland

CHEM31800

8

Poland

CHEM31800

8

Poland

CHEM31800

8

0

1

0

0

0

3

1

0

0

0

Puerto Rico

MATH190

1

Panama

ENGR10300

39

Panama

ENGR10300

39

3

4

1

2

4

6

3

3

0

1

Panama

ENGR10300

0

Afghanistan

EAS10600

11

Romania

MATH31601

4

2

1

0

0

0

0

0

0

0

0

Romania

MATH31601

4

Brazil

HS-COURSE_2

1

Afghanistan

EAS10600

11

0

4

0

0

1

1

1

0

0

0

Bahamas

HS-COURSE

27

Brazil

HS-COURSE_2

1

0

0

0

0

0

1

0

0

0

0

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: azanobrown

CA Forum: Charts and Graphs

What I've done in the past is create a new formula for your "value" field similar to this and put it in your cross-tab:if {original value field} is "" then [0] else {original value field}the purpose is to create a record value (e.g. 0) where there is no record. I hope that this helps.