enter image description hereenter image description here

****how can hide repeated data from my view table. i want to print employee Id and name field only once for each group. can you please help me out.****

I am fetching two table in view using JOIN.So few data gets repeated with respect to foreign key. So I need to hide those field value... Suggest me any solution...distinct and aggregation mixing up my data..

  • Can you show me the views configuration
    – Vamsi
    Jan 21, 2016 at 11:01
  • you can check my view configuration... Jan 21, 2016 at 11:29
  • I think this link may provide you the solution drupal.stackexchange.com/questions/38450/…
    – Vamsi
    Jan 21, 2016 at 11:59
  • if i am apllying distinct view and filter as a duplicate then all the related record along with row went out. Jan 21, 2016 at 12:23

2 Answers 2


Enable Aggregation in the advanced settings of your view and group the fields.

  • aggregation mixing all the things any other idea...using any function? Jan 21, 2016 at 13:16

you need to remove the month and aggregate the salary field as SUM, if you only want to suppress display of 2+ column values try the views merge rows module

  • i want my output like printing emp id, name only once and then whole buch of salray and month detail... Jan 21, 2016 at 13:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.