Hide rows when the displayed expression has zeros when a conditional expressions are implemented.
am using a pivot table where a list box is present for the expressions i have to display. The expressions which are selected are displayed in the table. But now is there a way that I can hide the rows that have 0 or null in all the expressions that are being displayed. And are showed if an expression with data for that row is selected. Hope am clear. Thank you in advance.