Skip to Content
0
Former Member
Jan 11, 2007 at 12:08 PM

Overall result incorrect when adding condition

38 Views

Hi,

When I adding a condition to report, the Overall result doesn't summarize the display records only, but also the data that invalid to the condition.

For example:

the data in the cube are,

Char KF

X 12

Y 15

Z 3

and if I created a report with a condition to get only records that its KF > 10, then will get like this result,

Char KF

X 12

Y 15

Overall result 30

but I want to get in the overall result, the sum of the records which only in the report result. i.e 27 in our example.

How can I solve this issue?

Best regards,

Mohamad