Drill Across "blanks"

[Former Member]

Hi,

Here is ny problem:

Data drilled down

CHR_A CHR_B KF

XXXXXX YYYYY 10

QQQQ ZZZZZZ 20

Data drilled Across

YYYYY ZZZZZ

XXXXXXX 10

QQQQQ 20

When I drill Across I need to fill in artificial values (constant value=1) in the non allocated cells (QQQQQ, YYYYY and XXXXX,ZZZZZ)

I hope it makes sense...?

Thanks in advance

[Former Member]

Hi Peter,

why do you need to fill in values there? If you drill across like you said, you should get 0 (zero) or empty (depending on suppress zero configurations) cells for the non-existent combinations.

Rgds.

Jürgen

[Former Member]

Hi Jurgen,

You are zbsolutely right, the behavior is correct and expected, however i need a cell counter that has value one for every cell, also the ones without values...

Peter