Skip to Content
0
Former Member
Jun 29, 2007 at 02:38 AM

Crosstab- how to suppress cells with 0 or null value

8 Views

Post Author: Alexis

CA Forum: General

Hi there!

Has anyone encountered this kind of issue? I cannot suppress the cell with 0 or null value. Is it possible?

e.g.

06/01/07

ProductA

MaterialA.1

MaterialA.2

MaterialA.3

MaterialA.4

120

120

120

120

ProductB

MaterialB.1

MaterialB.2

MaterialB.3

MaterialB.4

0

0

0

0

100

100

100

100

where: Material and quantity belongs to the same cell under SUMMARIZED FIELD.

The date and Product in ROWS.

Question1. How can I suppress the green field?

Question2. Is it possible that the row for MaterialB be moved to the left and occupy the green field?

Question3. What must be placed at the yellow field so that it won't sort or group its column according to its type?

I hope somebody can help me...

Thanks in advance!

Have a nice day!