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

how to get one value from multiple duplication for a key figure field

Hi expert,

I have a infoprovider, with following format:

employee hourly_rate action_type count of action

there are multiple rows for each employee, I want to create query as follows:

employee hourly_rate action_type count of action

in which hourly_rate is constant , only retriving one value from multiple rows for one employee, count of action should be summarized.

how to get this hourly_rate.

Many Thanks,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 29, 2014 at 02:46 AM

    Hi,

    put the employee in rows panel -> reaming object put it in free char panel.

    suppress the all result rows for the all object except employee .

    select the object -> go to query properties -> select display tab -> select result rows -> select suppress.

    select the employee -> go to query properties -> select display tab -> select result rows -> select always display. - now it will give employee wise hourly rate summarize data.

    Thanks,

    Phani.

    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.