AnsweredAssumed Answered

Need Help with cross tab report -text fields

Question asked by SudhaMovva on Feb 8, 2012
Latest reply on Feb 14, 2012 by philmodjunk

Title

Need Help with cross tab report -text fields

Post

 Hello everyone,

Would it be possible to create an FM report in the following format? I could find various ways to create a crosstab with calculation and number fields, but not with text fields.

I need to create a report that lists all the segments and products in that segments on the left side, vertically. On the top, the report should populate all the test plans available in FM. And the report should populate the market test description and FM record number in the cells corresponding to a particular segment and test plan.

For example, For the text  in blue , it should give the description of market test that was used in segment 1 in plan 5. It should also populate the corresponding FM records number in paranthesis.

Any help in matter will be greatly appreciated.

Thanks,

Sudha

    Year 2010 Year 2011  
Client Name and Year Product Plan 4 Plan 5 Plan 6 Plan #1 …..continues till all the plans in FM are listed
Segment 1 - Text Field Product Name1 - Text Field Market test description -text field
(Filemaker Record number)
Market test description -text field
(Filemaker Record number)
    …continues
Segment 2 Product Name2 Market test description -text field
(Filemaker Record number)
      …continues
…..continues till all the Segments in FM are listed …continues …continues …continues …continues …continues …continues

Outcomes