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