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.



      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.