Jump to content
Server Maintenance This Week. ×

manipulating line item data


This topic is 6603 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Picture_1.png

Link to comment
Share on other sites

  • 1 month later...

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.

Link to comment
Share on other sites

This topic is 6603 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.