Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to fractile a dynamic variable that ignores all selections.
Variable:
Aggregate by:
Tables:
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:
Please help!
If you want the expression to ignore all selections the you need to change the expression in the variable too: sum({1} sales).
If you want the expression to ignore all selections the you need to change the expression in the variable too: sum({1} sales).