Magic ETL

Magic ETL

Sum column when i have duplicates in other two columns?

I have these columns and I would like to sum the cost column only when the Publication and Year column have duplicates, so I can see the cost per Publication per year. Brain fart, I am assuming this is pretty straight forward? I'd like to do it in ETL if possible. Is there some SQL I can utilize to do this in the formula tile?

Tagged:

Best Answer

  • Coach
    Answer ✓

    So in an group-by tile, add Publication and InHomeYear to the groupings and do a SUM(Total Cost) in the bottom section which should result in what you are trying to achieve

Answers

  • Coach
    Answer ✓

    So in an group-by tile, add Publication and InHomeYear to the groupings and do a SUM(Total Cost) in the bottom section which should result in what you are trying to achieve

  • Thank you! I knew it was something stupid I did... In the group-by tile I had that intent but I had Total Cost as the third group by tile (not sure why) but that was what messed me up. Thanks!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In