AnsweredAssumed Answered

Pivot table in Filemaker 14 Pro Advanced

Question asked by ChrisC_3 on Jun 17, 2015
Latest reply on Mar 17, 2017 by MicheleOlson

Title

Pivot table in Filemaker 14 Pro Advanced

Post

As the title says, does Filemaker 14 Pro Advanced have any pivot table functionality, or do I have to do some sort of workaround with portals?

To put it another way, I'm interested in displaying data structured in a table like this:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
CodeCategoryValue
Code ACategory Aa
Code ACategory Bb
Code ACategory Cc
Code BCategory Ad
Code BCategory Be
Code BCategory Cf

As:

                                                                                                                                                                                                                                                                                         
CodeCategory ACategory BCategory C
Code Aabc
Code Bdef

 

It's worth pointing out that the "values" can be both numbers and text.

Outcomes