Build a View by month

Hi all,I have a database that tracks client ratings by month, so basically the user once a month opens a new document selects the customer and fills a bunch of fields with performance ratings…

I have several views that displays all kind of information, flat, expandable, etc.

Now I was asked to build a view that could display the Client and every single month in columns and under each month the Overall Rating ( Overall Rating is a field that the user fills ).

Something like this:

Client … Jan … Feb … Mar …


A … 5 … 4,5 … 3

B … 4 … 2 … 7,8

I can’t find a way to make this happen.

Thank you all for your help.

Subject: Answered in the other forum

Please don’t cross post.