Subtable sorting and grouping

I set up a sort on my subtable that is essentially: Field A, Field B, Field C   (ascending). I then set up a group on Field B. My table now sorts by Field B (grouped), Field C and seemingly ignores Field A as items which have a lower value in Field A show up after items with a higher value in Field A. 

 

Is there anything I can do to fix this so Field A remains my primary sort but I group the records based on value in Field B?

 

Thank You,

Dave

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Dave,

      when using grouping the primary sort HAS to be the field you are grouping on.  So you can't group by field b but have the primary sort be field a.

    Keith

    Like
Like Follow
  • Status Answered
  • 1 yr agoLast active
  • 1Replies
  • 10Views
  • 2 Following

Juiced Links