2 Replies Latest reply: Jan 9, 2013 7:35 AM by Darren Johnson RSS

    Aggregation

    Darren Johnson

      Hello,

       

      I have a table like the below....

       

      ModelItemColourViews
      A1BLUE4000
      A1GREEN4000
      A1BLACK4000
      A2BLUE1200
      A2GREEN1200
      B3RED2600

       

      What I want to do is add up the 'Views' for each model, but removing the duplication by colour.

      So that the total views for item '1' = 4000, and item '2' = 1200 so the total for model 'A' would be 5200.

      I've tried a couple of different Aggr() formula variations but I'm having some trouble! Any advice would be much appreciated!

       

      Thanks

       

      Darren