Home › Forums › Power Pivot › Hide blank pivot table lines Tagged: Water analyzer This topic contains 1 reply, has 2 voices, and was last updated by snehaagarwal1 3 years, 9 months ago. Viewing 2 posts - 1 through 2 (of 2 total) Author Posts April 15, 2019 at 5:44 pm #15497 sjhc1177Participant Started: 25Replies: 28Total: 53 Hi, I have a pivot table that I would like to hide blank lines. IE and item is bough and returned. So my measure shows that there is activity. But I would like to hide all employees who’s net sales are zero. PAYROLL SPH:=iferror(CALCULATE([NET SALES]/([Total Hours Worked]+[Total Hours Worked MGMT])),””) Thanks April 16, 2019 at 6:52 am #15501 snehaagarwal1Participant Started: 0Replies: 0Total: 0 This reply has been reported for inappropriate content. Vasthi Instruments are global leaders in manufacturing of Water analyzer and have been supplying instruments to customers worldwide. Author Posts Viewing 2 posts - 1 through 2 (of 2 total) The forum ‘Power Pivot’ is closed to new topics and replies.