Getting Associated Values From DrillFilters

[xlbo]

Hi all - hope someone can help. I currently have a report that uses a Drill on &quot;OutletID&quot;. Associated with this dimension are things like Outlet Name / Address etc. I know I can show which &quot;OutletID&quot; is currently selected in the report by using Drillfilters(<OutletID>) but I was wondering if, without making them drillable, whether it is possible to get the associated dimensions (like Name), with a formula I've tried :
=&quot;YTD Variance To Budget For Outlet &quot; & DrillFilters(<outletID>) & &quot; &quot; & <Property House Name> where (<outletID>=DrillFilters(<outletID>)) - but it doesn't like the syntax - seems I can't use the where statement with an object...???

can anyone advise if this is possible and if so....how???

TIA
Geoff