none
Need help grouping/displaying something RRS feed

  • Question

  • I'm trying to get the subtotals for the colored columns correct.  The second gray one that says "Location" wasn't totaling despite having numbers in the column.  I know the SUM formula is correct because it's the same as the other working ones, just different field names.

     


     

    Image and video hosting by TinyPic

     

     

     

    I figured out that the grouping was incorrect.  The grouping is as follows:

     

    Group1:  Fields!Ozp.Value

    Group2:  Fields!Dst.Value

    Group3:  Fields!LR_Ozp.Value

     

    If I add the =Fields!LR_OZp.Value to Group1 under the =Fields!OZp.Value that column gets subtotaled correctly, but it stops grouping the origin ZIP codes together.  I don't know how to maintain my layout but get the sub totals working also.

     

    I'm also not sure how to explain this, so if you need any other info let me know.

    Wednesday, March 9, 2011 8:43 PM