6 Replies Latest reply: Aug 27, 2013 10:54 AM by Steve Zagzebski RSS

    TOTAL - Set Analysis

    Steve Zagzebski

      Data:

      Client    Month   Sales

      A             Jan       100

      A             Feb        50      

      B             Jan        200

      B              Feb       100

       

       

      I know this should be simlpe but I am drawing a blank on how to incorporate the TOTAL function. What I want to be able to do is add the total for each month regardless of the client:

       

      Object:

      Client   Month    Sales

      A          Jan        300

      B          Jan        300

      A          Feb        150

      B          Feb         150