1 Reply Latest reply: Nov 10, 2015 4:06 PM by Stefan Wühl RSS

    AGGR/fractile - dimension problem

    Matthias Hansemann

      Hi all,

       

      I got a table with lots of prices which I calculate by the revenue and the quantity. Now I want to split theses prices by the fractile function and aggregate them by one or two dimensions (product (and department)).

       

      DepartmentProductRevenueQuantityPriceq(75%)
      A12312026067,50
      A12321037067,50
      B2341711719,25
      B2344022019,25

       

      It should look like that but I don't know how to do it.

       

      Thanks a lot,

      Matthias