Skip to main content
Solved

Pivot Table Settings "Is Empty"

  • Aug 13, 2025 11:09 PM UTC
  • 1 reply
  • 102 views
  • Translate All

Forum|alt.badge.img

Hi,

I am modify a pre-build payroll report called Employee Detail Data (MPPP4075). I’ve created my changes with the “Edit Pivot Table” button, and “Saved As” a new pivot for this report.

For one of the Rows, if there is no value, I would like for nothing to be returned in that cell, i.e. a blank cell. But unfortunately, the system is returning the words “Is Empty”.

The setting is currently set as per screen shot, with nothing entered into this setting.

Can anyone help to make this cell blank?

?

Best answer by sangland

Hi, just have to put in something innocuous like a dot . (it won’t display a space character)

View original

1 reply

sangland
Varsity I
Forum|alt.badge.img
  • Varsity I
  • Answer
  • Aug 14, 2025 9:01 AM UTC

Hi, just have to put in something innocuous like a dot . (it won’t display a space character)

Translate