Skip to main content
Answer

Pivot Table Settings "Is Empty"

  • August 13, 2025
  • 1 reply
  • 41 views
C
Jr Varsity III
Forum|alt.badge.img
  • CCC
  • Jr Varsity III

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)

1 reply

sangland
Varsity I
Forum|alt.badge.img
  • sangland
  • Varsity I
  • Answer
  • August 14, 2025

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

Regards Simon
Graeme Laughton-Mutu
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved