CrossTab Summary - Need Help

[paulsyhand]

Hello,

Is there any way to have record data pulled into a crosstab summary based on month. I can get numerical data to flow, but not text fields associated with that number.

I am trying to make an media schedule for ad buying. The structure of the report is seen in the attachment. I was able to get the data to pull for one month, but if there is an ad running in the same publication in the same year the other data won't show up. See "Aftermarket Business" row.

I'm using a calculation for each month to grab the data:

"Details Jan"

Let (Month = Month(Issue Year) ;

Case (Month = 1 ; GetField ( "Job # ")

&"¶"&GetField ( "I.O. # ")

&"¶"&GetField ( "Space Close")

&"¶"&GetField ( "Deadline")

&"¶"&GetField ( "Size ")

&"¶"&GetField ( "${New or Pickup} ") ; "" ))

I have limited experience with filemaker. Any thoughts and/or comments would be appreciated!

Thanks so much.

[Søren Dyhr]

Read this:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html

--sd

[paulsyhand]

Thanks for the reply!

This is how I have the file initially setup, but can't seem to get data to show up in more than one month. the summary works great, but adding additional field content doesn't.

see attached example file. I apologize in advance if I do not make complete sense.

Thank you for taking your time to look at this.

CrossTab_Summary_withData.zip