Hi All,
I have the following Calculated Dimension
if(aggr(Rank(ImpactRU),BUnitName,ReportingName,CoreBPName,SubBusinessProcessName,DeficiencyID,CalculationBasis) = 1, CalculationBasis,)
This returns me the row with the highest impactRU - I can then supress nulls on this column to get the top impactRU
However I also a set anaylis expression
count({$<DeficiencyCompliance = p([Control Compliance]),DeficiencyOpen={'Yes'} >} DeficiencyCount)
I want to find the impactRU using the AGGR function after the set analysis expression has been applied. however at the moment the AGGR function ignores my set anaylsis.
Can anyone help me conbine these two formulas?
Many thanks for you help