Ignore Dimension Selections in table

[satishkurra]

Hi All

I'm having trouble with ignoring the selections in dimensions. Attached is the qvf.

On selection of country, the values of 1st quartile, median and 3rd quartile is working. But on selection of SalesPerson or Outliers (IQR) the values are recalculating. In this case even if I select Outliers (IQR) selected, I want to show the 1st quartile, median and 3rd quartile only by Country and not by Outliers (IQR) or SalesPerson.

Outliers (IQR) is a calculated dimension and the values I want to keep it constant by Country is 1st quartile, median and 3rd quartile

Can someone help me with this?

Thanks

Satish

[satishkurra]

Adding expressions to make it easier to respond.

Measure: Sum(Sales)

1st Quartile: Fractile( total <[Country]> Aggr( Sum(Sales), [Country], [SalesPerson] ) ,0.25 )

Master Dimension

Outliers (IQR): =
aggr({<SalesPerson=>}
pick(
match(
(Sum(Sales) > Fractile( total <[Country]> Aggr( Sum(Sales), [Country], [SalesPerson] ) ,0.75 )) & 'a' & (Sum(Sales) < Fractile( total <[Country]> Aggr( Sum(Sales), [Country], [SalesPerson] ) ,0.25 ))
,'0a0','-1a0','0a-1','-1a-1')
,'Within Box','Highliers','Lowliers','Error in Calculation')
, SalesPerson)

Now with selecting the value from Outliers (IQR), the 1st Fractile value should not change and calculate w.r.t Country