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

    Totalling info within a value list



      Totalling info within a value list




      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.