I have the following configuration with my drupal website:

  • Taxonomy vocabulary: Procedure
  • Users Role: Doctor
  • Node Type: Surgical Operation

When I create a "Surgical Operation" node, I can select a procedure (abdominoplasty, breast augmentation, etc...) and a doctor (users with doctor role) via entities.

What I would like to do now is create a View that displays what operations have been performed, how many times, and by what doctors in a table:

Table example

So far I have tried the following modules without success:

  • Views Aggregator Plus;
  • Views Calc;
  • Views Table Group;

How should I proceed? Should I create a module myself to display these informations?

Thank you for your help.


I had a very similar problem and I could solve it using Views Matrix module. It has only a dev version for Drupal 7, but it did the job perfectly.

Look at this question, it's almost the same except that I didn't need to count the items: Matrix view with content as columns and taxonomy terms as rows

There is also another answer to that question which I tested and it works as well.

| improve this answer | |
  • Thank you for your answer! I was able to create the table with "Views Matrix" and "Views Table Group" modules. However, I can't find a way to display the total in the last row and the last column of the table, I think the only way is to create a custom module... – Pipolaye Jan 13 '14 at 22:55
  • For what purpose did you used 'Views Table Group' module? – Елин Й. Jan 14 '14 at 7:43
  • I couldn't find a way to add a sum of the columns at the end of the table using 'Views Matrix' module, since the other views plugins that provide this functionality are also using the display format. – Елин Й. Jan 14 '14 at 8:05
  • There are 2 ways I can suggest you to go with, I'll update my answer. – Елин Й. Jan 14 '14 at 8:06
  • But I have to work now, please remind me in 8 hours to update my answer with the suggestions. In short, I'll suggest you to use attachment display or using the template based answer to my problem instead of Views Matrix. – Елин Й. Jan 14 '14 at 8:18

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.