Now when you return to the spreadsheet, the zero lines should be hidden. Un-select the checkbox next to the 0 value and click on the X in the top left of the Quantity window. You should now see a Quantity drop down appear in row 1 in your spreadsheet.Ĭlick on the arrow to the right of the Quantity drop down box and a popup menu will appear. Users can create their own compelling reports and analytical applications, easily share insights, and collaborate with colleagues through Microsoft Excel and SharePoint. We want to hide these lines from being displayed in the pivot table.Ĭlick somewhere in the pivot table to display the PivotTable Builder.ĭrag the Quantity field from the "Field name" box to the Report Filter section. PowerPivot empowers users of all levels to access and mashup data from virtually any source. Below is a spreadsheet that contains values that are zeros. I have a table with two columns Order ID and Total (Sum of Quantity) and I would like to hide the Orders with no quantity total against them - is this possible?Īnswer: Let's look at an example. Question: Is there a way to hide zero valued lines within a pivot table in Microsoft Excel 2011 for Mac? i.e.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |