7 Replies Latest reply on Mar 17, 2017 7:06 AM by MicheleOlson

    Pivot table in Filemaker 14 Pro Advanced

    ChrisC_3

      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.