queary on how to disable rows with empty values
 

Hi,
In my excel workbook, I am having a dashboard which has a row called area.
I have regions under the area. the data for this is comming from pivot table
in another sheet say sheet 2.
Suppose there are two regions say X and Y under area. now, if in the pivot
table in sheet 2 if we are selectin only x then in the dashboard its showing
values for X but the next row its showing 0 in all cells. I dont want that. I
want only the rows with values to be displayed. How can i achieve this? any
help..

Thanks in advance,

Best Regards,
Azhar