1 Reply Latest reply: Sep 23, 2015 9:20 AM by Gysbert Wassenaar RSS

    Fractile a dynamic variable?

    Zach Paz

      Hi all,


      I am trying to fractile a dynamic variable that ignores all selections.



      • vMetric = sum(sales)


      Aggregate by:

      • Product



      • Percentile
        • This is a table that has 0% to 100% by 10% increments and is used as the


      Current expression:


      =fractile({1<Market=P(Market)>}aggr(nodistinct ($(vMetric)),Product,Market),1)



      I need to have a table that has the percentiles by each decile by two dimensions:

      1. Percentile
      2. Market

      Please help!