mgerard802
Technical User
I have a pivot table with number of 0 amount rows. Is there a way I can suppress those rows to make the report easier to read?
Thanks
Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Suppress 0 amount rows in a Pivot Table
- Thread starter mgerard802
- Start date
- Status
SkipVought
Programmer
Hi,
Make a new column with a heading of data outside of your Pivot Table with the values containing the zeros.
Do an auto filter using that new column of data and filter out the data you do not want to see.
VOLA!
Skip,
Skip@TheOfficeExperts.com
Make a new column with a heading of data outside of your Pivot Table with the values containing the zeros.
Do an auto filter using that new column of data and filter out the data you do not want to see.
VOLA!
Skip,
Skip@TheOfficeExperts.com
SkipVought
Programmer
Also you might want to hide that column as well
Skip,
Skip@TheOfficeExperts.com
Skip,
Skip@TheOfficeExperts.com
In pivot table options (right click on PT) do you have
"For Empty Cells Show" ticked
If so, untick it
Other than that make sure that in the field options, you havn't ticked "Show Items with no data"
Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Get the best answers to your questions - faq222-2244
"For Empty Cells Show" ticked
If so, untick it
Other than that make sure that in the field options, you havn't ticked "Show Items with no data"
Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Get the best answers to your questions - faq222-2244
- Status
Similar threads
- Locked
- Question
- Locked
- Question