Home › Forums › Power Pivot › Hide blank pivot table lines

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by  snehaagarwal1 5 years ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • April 15, 2019 at 5:44 pm #15497

    sjhc1177
    Participant
    • Started: 25
    • Replies: 28
    • Total: 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

    snehaagarwal1
    Participant
    • Started: 0
    • Replies: 0
    • Total: 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.