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

[Former Member]

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,

[KodandaPani_KV · Accepted solution]

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.