queary on how to disable rows with empty values

A

Azhar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
pivot table not getting updated 2
Dealing with a Pivot Table (when I don't want to) 0
Mail Merge Help 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Copy rows with values in sheet 1 to next empty row in sheet2 2
Sort on 3 columns when number of rows vary daily 1

Top