Skip to Content
0
Nov 03, 2009 at 06:11 AM

Drill across leads to 'X' in %CT function

22 Views

I am using the function %CT which gives me the share of a key figure against the subtotal.

This works beautifully, except when I try to drill across.

Drill across results into u2018Xu2019 values.

Example:

KF 1 %CT

A 2 33%

B 4 66%

Total 6 100%

KF1 can be split in Y / N by drilling across. I would expect:

KF 1 KF1 %CT %CT

Y N Y N

A 1 1 25% 50%

B 3 1 75% 50%

Total 4 2 100% 100%

But instead the % show u2018Xu2019u2026.

Does anybody know what the problem could be?

Thanks,

Jan.