Incorrect Overall Result on % with Condition.

39 Views

hi all,

i have data as below

cust count deal deal %

=================================

10 5 0.5

30 3 0.1

4 3 0.75

2 2 1

================================

46 13 3.538461538

=================================

and when i create a Conditon TOP 3 cust count, it returns wrong values on Overall result. (it still giving the Full count instead of based on condition value).

cust count deal deal %

=================================

10 5 0.5

30 3 0.1

4 3 0.75

================================

46 13 3.538461538

=================================

After seaching Sap notes and many forum, i guess the workaround to this is to set 'SUmmation' on 'Calculate result as' for each of the Key Figure. The result turn to be OK for Key figures But NOT on percentage.

cust count deal deal %

=================================

10 5 0.5

30 3 0.1

4 3 0.75

================================

41 11 1.35

=================================

for above, Deal % should be 11/41 --> 4% Instead of 1.35%.

The problem of 'Calculate as summation' is not applicable to any subsequent calculate due to it is only for display only. Thefore i can't use it for any further calculation.

I'm sure many out there have this simple requirement, any help would be appreaciated.