Satisfaction Tracking

[CircuitBoards11]

I currently have an excel spreadsheet that displays customer ranking per month and each sheet displays per fiscal year.

(For Fiscal Year 2012)

_Jan'11_____ Feb'11____March'11_______Average'11____________

Joe`````|```5````````````````3`````````````1```````````````````````3

Jon`````|```4````````````````2`````````````5```````````````````````3.67

Juan```|```3````````````````3``````````````2```````````````````````2.67

In filemaker I have a customer table and a ratings table. So one customer can have many ratings each record being a month. When displaying this as a list, It displays the customer then in a tiered effect it does the ratings. With the effect as shown below. Is there anyway to display it as above rather than as below? I would like it to be like an excel sheet.

_Jan'11____Feb'11____March'11_______Average'11____________

Joe````|``5```````````````````````````````````````````````````````5

````````|````````````````````3`````````````````````````````````````3

````````|````````````````````````````````````1`````````````````````1

Jon```|```4``````````````````````````````````````````````````````4

````````|````````````````````2`````````````````````````````````````2

````````|````````````````````````````````````5`````````````````````5

One way I was thinking is to have another table to take each months ranking record (Which contains only the ranking for one month) and have it be a fiscal year record (so the record would contain each months record for the entire fiscal year) so it displays it per year rather than per month.

Is ther any other way to display it without having an additional table?