0 Replies Latest reply on May 14, 2013 8:50 AM by Brittany Fong

    Using dates with two connections to get correct grand total

    Brittany Fong

      I have a sample workbook here with two connections.

       

      Connections:

      Jan-April: Has data Jan- April (must be secondary connection)

      Jan-Mar: Has data Jan-Mar (Primary Connection)

       

      The "Jan-Mar" connection needs to be the primary connection.  When I make a grand total calculation broken down by month I get 21 (total Jan-Mar) however when I view this calculation at the year level I get 28 (total Jan-April).

       

      I want to show a total of 21 at the year level.