Forumla in pivot table

billym007

New Member
Joined
Jul 5, 2011
Messages
7
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??
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,205
Messages
5,527,399
Members
409,760
Latest member
zeeshansyed

This Week's Hot Topics

Top