Drill across leads to 'X' in %CT function

[Jan_van_Ansem]

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.

[Former Member]

Hi Jan

X comes when there is not assigned value.

In your case , it is unable to calculate when KF is drilled down / accross with Y/N. Thats the reason why 'X' is coming.

Cheers

Chanda