4 Replies Latest reply on Aug 20, 2013 11:42 PM by Robin Goibert

    2 aggregations on one table

    Robin Goibert

      Hi,

       

      What I would like to do is to have two different levels of aggregation.

      I have attached an example, I want the "sales" to be aggregated (sum) by country, but I want the "profit" to be aggregated by State.

       

      I succeed in making a table calculation that make the running sum of sales in one country, but I want to have only the sum of sales in a country, with only one figure.

       

      So if you have a solution, it will help me a lot.

       

      Thank you in advance,

      Best regards,

      Robin