Total Count of a List Coloumn based on Values of Another Coloumn

Question

I want to maintain an Issue List, which is reported  by all of my customers for my product.

Customers : Customer 1, Customer 2, Customer 3, Customer 4 and so on

Issue Status : Open, Inprogress, Closed

I am looking for a result which shows for each customer how many issues are Open, In-Progress & Closed

Based on this data I want to display the pie chart for each customers

Answer 1

Hi vivekraog,

For this issue, you can create another list customer to store the customers’ information, and add three columns to count the three Issue Status.

Add a update event receiver to the Issue list. When the Issue Status was updated, find the same customers item in the customer list and then update the count of the status. For more information, please refer to : http://msdn.microsoft.com/en-us/library/ms437502.aspx

Best Regards.

Answer 2

Finally some reply for my query. Thank you very much Yaoyaochen.

I forgot to mention that I am not a developer, I dont have MS Visual Studio.

I am just a user of MS Sharepoint 2010 installed on a remote server. But I do have access to MS Shrepoint Designer.

Is there any solution to achieve the same without manually writing the code and just by using MS Shrepoint features or Shrepoint Designer features?

This would be an ideal solution for me.