pivot table exclude lines with 0 value

[Dharris144]

I have a pivot table for sales orders. Each order had 1-10 lines with item description Sales order number quantity and unit price.

It works fine but i would like to filter out any Sales Order with one line that has a 0 unit price.

so if an order has ten lines, 9 have unit price values but one does not. I do not want to see all 10 lines. pivot

 

[jorismoerings]

Hi,

As to my knowledge. Excel Pivot Table doesn't distinguish if data has value 0. So any line in a pivot is shown as soon as the data cache contains data.
Not showing the lines with value 0 can be easily done by applying a filter which deselects the 0 value.

Hope this helps.