topic Re: Ignore Dimension Selections in App Development

Ignore Dimension Selections

satishkurra — Tue, 12 Nov 2024 14:50:39 GMT

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 — Tue, 12 Nov 2024 17:20:20 GMT

maybe like this:

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

- Regards, Matheus

satishkurra — Tue, 12 Nov 2024 17:28:31 GMT

Well the below tweak worked for me.

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