manipulating line item data

[swf]

I have tried very hard to normalize my data and have entries in line item table. However, sometimes you want to manipulate the data to look different for reporting an a line item is not the best way. In the attached file does anyone know how to convert the top into the bottom table. I need to export into excel (a subsummary report is not helpful) to send in a mandated report.

[bruceR]

You're talking about a crosstab, a kind of report that is built in with Excel and Panorama. It is harder to do with FileMaker but there are many cross tab example templates out there.