zero dollar invoice shows in Table Box but not Pivot/Straight Table

[#1]

I have invoices showing up in my Table Box where there is only one line item with zero sales amount.

When I sum the invoices up in a Pivot or Straight Table these invoices do not show up. Is there a way to force these zero dollar invoices to show up?

Thanks for your help

Jimmy

[pover · Accepted solution]

In the Pivot/Straight table properties window go to the presentation tab and remove untick the option to suppress zero values.

Regards.

[#3]

duh. hate being a newbie 😉