1 Reply Latest reply on Sep 16, 2009 2:04 AM by comment_1

    Totalling info within a value list

    imgaryshap

      Title

      Totalling info within a value list

      Post

      Hello,

       

      In filemaker 8.0 on mac, I have a field that contains a value list holding several items.

       

      I know how to set-up a sub-summary part in my layout that will get the total number (count) of each item in the value list, respectively, pending on how I sort my records.

       

      My question is - how can i get individual totals for each item in the value list in the Leading Grand Summary?

       

      so if I have a value list containing A, B, and C.  I'd rather have at the top of my report  "Total A:_____"   "Total B:______" "Total C:________", rather than doing a sort where there will by a sub-summary header that says "Total A:____" then list the records that were marked as "A", followed by a header that says "Total B:_______" followed by the records marked as B, etc...

       

      I hope I clearly stated my issue.

       

      Thanks so much.

       

      -G.