Suppress Dimension if All Expressions Do Not Return Values
I have a bar chart with one Dimension (Job Title) and two Expressions (avg(Hourly Rate) and (avg(Day Rate). I only want to see the dimension when it returns values for both expressions. How is this accomplished? I tried a select in field action as well so that the entire sheet would filter if the two expressions were true on sheet activate, but that didn't work. Please advise.
Re: Suppress Dimension if All Expressions Do Not Return Values
Thank you as well. Unfortunately that did not work for me either. Please see the attached example where I would want to suppress the Accounting Assistant job title from the chart because it does not have any Daily Rates data to show.