how to filter out data by total value.

[Former Member]

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,

[Loed]

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

[Former Member]

Hi,

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

Fathima.

[Former Member]

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

[former_member360228]

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