4 Replies Latest reply: Dec 5, 2016 1:35 PM by Matheus Colares RSS

    Sum(Total<>)

    Matheus Colares

      Hi guys.

      Hlep me with somethig, for example:

      I have some products...
       

        Product               Segment          Amont Sales

        Heineken              Beer                10

        Budweiser             Beer                20  

        Blue Label            whisky              30

        Jack Daniels         whisky              40

       

      If i make :

       

      Product               Segment          Amont_Sales          Sum( Total Amont_Sales)

        Heineken              Beer                10                         100

        Budweiser             Beer                20                         100   

        Blue Label            whisky              30                         100

        Jack Daniels         whisky              40                         100


      Right?


      But i dont wanna TOTAL , i want TOTAL by Segment,  in the other words, the table must be like this:


      Product               Segment          Amont_Sales          Sum( Total <Segmente> Amont_Sales)

        Heineken              Beer                10                         30

        Budweiser             Beer                20                         30

        Blue Label            whisky              30                         70

        Jack Daniels         whisky              40                         70



      But "Sum( Total <Segmente> Amont_Sales)" not its worked in my example...


      Someone knows how i do that?


      Thank you.