Ignore Dimension Selections

[satishkurra]

Hi All

For the below expression, how can we ignore the selections on dimension, SalesPerson?

Fractile( total <[Country]> Aggr( Sum(Sales), [Country], [SalesPerson] ) ,0.25 )

[MatheusC · Accepted solution]

maybe like this:

Fractile({<[SalesPerson] =>} total <[Country]> Aggr( Sum({<[SalesPerson]= >} Sales), [Country], [SalesPerson] ) ,0.25 )

- Regards, Matheus

[satishkurra]

Well the below tweak worked for me.

if(Sum(Sales) = 0, 0,
Fractile( {<SalesPerson=>}total <[Country]> Aggr( Sum({<SalesPerson=>}Sales), [Country],SalesPerson ) ,0.25 )
)