4 Replies Latest reply on Oct 24, 2018 8:35 AM by Ciara Brennan

    How to Subtotal

    Tom Wikle

      I have an Excel spreadsheet that shows values for Campaign Names. I want to subtotal the Clicks, Impressions, Total Spent, and Video Views by the Campaign Name. In Excel you would select all the data, go to the Data tab, sort by the Campaign Name, and then select the Subtotal tab to Sum values based on change in Campaign Name. Pretty easy and straightforward.

       

      I don't see how this is done in Prep. The Aggregate step doesn't keep the data together. Group on the clean doesn't appear to work this way either. Can I do this in Prep, or is it easier to do this in Excel?

      I included a sample file to show what I am trying to accomplish.