Skip to Content
author's profile photo Former Member
Former Member

how to filter out data by total value.

Hi expert,

I have following requirement for a query:

employee overtime_reason_code overtime_hours

1 1 1

2 6

3 10

so for an employee, if total overtime_hours>8, then it will be displayed in the report, otherwse , it will be filterred out from the report.

Many Thanks,

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jul 22, 2014 at 05:44 PM

    Hi,

    You can filter out the values while loading in the cube. But if you want the data to be in the cube and only filtered from the report then use Conditions in the BEx report.

    Regards,

    Arminder Singh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2014 at 06:28 AM

    Hello,

    Please create the condition on overtime_hours as total overtime_hours >8 and transfer, save query. It will filter out remaining rows < 8hours. Hope this helps.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2014 at 07:33 AM

    Hi,

    Please create a condition on the BEX query and activate the condition.

    Fathima.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 26, 2014 at 01:58 PM

    Hi Bo,

    This suggestion will add another KF in column:

    Create a FORMULA and insert the OVERTIME_HOURS in it..Go to aggregation tab and make it TOTAL with reference characteristic to EMPLOYEE..

    Then make a CONDITION for the FORMULA you have created so that if total is <8 hours, it will not be shown..

    The result will be like this:

    employee overtime_reason_code overtime_hours new formula

    1 1 1 17

    2 6 17

    3 10 17

    so if you have employee 2 with total of less than 8 hours, it will not be shown..

    Regards,

    Loed

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.