Is a pivot table possible in Filemaker?

[AlexCam]

I have to databasize a table that is actually presented as a pivot table this way:

Company | Year1 | Year2 | ....

Company1| Sales | Sales

Company2| Sales | Sales

Now what i did is make a table Company | Year | Sales|

Now even though I can get it sorted as I like they want previous years to appear side by side as above and to make it more interesting the company number varies (Not all companies are present all years)

If nothing is possible in excel I guess would need to export to a spreadsheet and move on from there but it would be nice if there where a way to layout it in file-maker even if it might be just for printing

Thank for any hint, and for your time :

Edited September 26, 2009 by Guest