Home Forums Power Pivot Hide blank pivot table lines

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
  • #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

     

    #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.

Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘Power Pivot’ is closed to new topics and replies.