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

    Pivot table in Filemaker 14 Pro Advanced



      Pivot table in Filemaker 14 Pro Advanced


      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:

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


      CodeCategory ACategory BCategory C
      Code Aabc
      Code Bdef


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