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 '16 at 11:01
  • you can check my view configuration... – Mukesh Gami Jan 21 '16 at 11:29
  • I think this link may provide you the solution drupal.stackexchange.com/questions/38450/… – Vamsi Jan 21 '16 at 11:59
  • if i am apllying distinct view and filter as a duplicate then all the related record along with row went out. – Mukesh Gami Jan 21 '16 at 12:23

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

| improve this answer | |
  • aggregation mixing all the things any other idea...using any function? – Mukesh Gami Jan 21 '16 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

| improve this answer | |
  • i want my output like printing emp id, name only once and then whole buch of salray and month detail... – Mukesh Gami Jan 21 '16 at 13:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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