If you are reasonably familiar with SQL I would recommend using Forena for this:
http://drupal.org/project/forena (full disclosure: I'm the module maintainer for forena)
It used to be you could do this with views group by , but I'm not sure it's being maintained anymore.
Dave
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Yasemin Barutçu Sent: Friday, November 21, 2014 1:24 AM To: support@drupal.org Subject: [support] How to create a Views table with counts per value of a field
Hello, I have a report page and I want to create a summary page for my report.
There are multiple fields and that fields have multiple states; Code (unique) | (Status) | Department 1 | Open | Network 2 | Close | Network 3 | Close | Security 4 | Close | Security 5 | Open | Security 6 | Open | SQL 7 | Open | SQL
8 | Close | SQL
By using these table I want to generate a view where each department has one row. For each row you can see how many Close or open cases have.
Departmant | Open | Close Network | 1 | 1 Security | 1 | 2 SQL | 2 | 1 Or if I expand the status like Open, Close, Resolved
Departmant | Open | Close | Resolved Network | 1 | 1 | 1 Security | 1 | 2 | 0 SQL | 2 | 1 | 2 And for the sum of the cases;
Departmant | Cases | Network | 2 | Security | 3 | SQL | 3 | Could you please help me how to generate a page like this ?
Thanks, No RegreTs