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!

[Gysbert_Wassenaar · Accepted solution]

If you want the expression to ignore all selections the you need to change the expression in the variable too: sum({1} sales).