2 Replies Latest reply on Nov 25, 2013 8:16 AM by Ben Neville

    Maximum of Summed Values

    Austin Barry

      I would like to find the Maximum value for the Sum of marketing spending values....Here's my problem.

       

      I have to aggregate this spending data based on StoreName and Date. There are many stores and many spend transactions for a single month. I want to simplify it to a single monthly spend for a single store (e.g. Sum(Spend) for January for Location A). From there I want to find the Maximum summed value by month for all of the stores.

       

      So...      Sum(Spend) forLocations A for January = $300

                   Sum(Spend) for Location B for January = $400

       

      Max = $400

       

      It keeps returning the Max value for a single transaction as opposed to the Sum of a Locations total transactions.

       

      Please help!

       

      Thanks