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.

       

      Variable:

      • vMetric = sum(sales)

       

      Aggregate by:

      • Product

       

      Tables:

      • 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!