Skip to Content
0
Former Member
Nov 17, 2006 at 10:30 AM

Drill Across "blanks"

31 Views

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