I have a chart which is team over location. Eg - chart count as Resources by Team, Location|addcoltotals|addtotals (used appendpipe instead of addcoltotals as well) Label - US, AUS, UK Team 1 Team 2 Team 3 I am trying to do a custom drilldown to show all team members in that location when selecting the total row. The drilldown I have works fine if you select anything other than the addcoltotals and/or addtotals values. The issue I am having is changing the “null” to a * and the Total to a * to put in the drilldown search. It works if I rename the labels for the total columns and rows to * (but would like it to say total for the users) but using eval to make a variable hold * if it's null works, BUT passing this variable into the search for the drilldown doesn’t work. Dilldown search I have: (big long search string) |search Team = $TeamTok$ "Location" = $LocationTok$ Drilldown search I would like (big long search string)| eval Search1 = if ($TeamTok$ = “null” ,”*”,$TeamTok$)|search Team = "Search1" "Location" = $LocationTok$ ... View more