Forumla in pivot table

[billym007]

Wonder if anyone can help. I have create a pivot table which calculate the combined revenues for sproduct set, however I would just like to show a yes if revenues are over £0 and a no if revenues are blank

Is this possible??

 

[Andrew Poulsom]

First apply this number format to the field in the data area:

[>0]"Yes";;"No"

Then in PivotTable Options check 'For empty cells show" and type No in the box to the right.