6 Replies Latest reply on May 10, 2012 6:07 AM by Fionnuala Gibney

    Problem calculating totals when there's 'duplicate' items in the data

    Fionnuala Gibney

      Hi all,

       

      I have data that has different categories assigned to it, and so I have duplicate Sales totals for a given ID, I'm looking to get a total value for sales, one which takes the maximum/average of the sales per Sales ID and then gives me a total for it -- I just want to get one number back, in this case 45000. (and not look at the ID by ID sales)

       

      I'm struggling with this -- any ideas? I have vague thoughts on pass-through functions, but when I try that I get scaler/aggregation issues with the calulcations

       

      Thanks,

      Fionnuala