Pivot Table - Show total value those more than or equal to 2

[Shermaine2010]

How to show total value those more than or equal to 2 in pivot table.

Attached is sample.

[teylyn]

Hello,

A value filter will hide rows or columns, but only if all their values don't meet the criteria. In this case, there are 1's in every column, so all values will show.

What you are after looks more like conditional formatting. Select the values and create a conditional format that uses a formula like

=F3<2

and set it to custom number format ;;; or white font on white background.

cheers, teylyn

[Shermaine2010]

Hello,

A value filter will hide rows or columns, but only if all their values don't meet the criteria. In this case, there are 1's in every column, so all values will show.

What you are after looks more like conditional formatting. Select the values and create a conditional format that uses a formula like

=F3<2

and set it to custom number format ;;; or white font on white background.

cheers, teylyn

Different with conditional formatting. I dont that the value show at columns. Conditional formatting just change the font color to white however value still at there.

[teylyn]

As I said, filters in pivot tables look at the whole row and the whole column. They won't do what you want. The cell for Row label CCCCC in Month 2 is visible in the table, so its value will show. The only way I can think of is to hide it with formatting.

Maybe you can step back a bit and explain the bigger picture of what you would like to achieve.

[cbatrody]

Hi,

If you slightly modify the field settings and change the display to "Classic Pivot Table" layout, you can filter for months with values >=2.

[Shermaine2010]

Hi,

If you slightly modify the field settings and change the display to "Classic Pivot Table" layout, you can filter for months with values >=2.

Look greats. However, I am facing another issue.
With this adjust, ID columns might blank for those same ID with differen month.

AAAA 03 3
02 4

Any quick solution to show all ID?

[Shermaine2010]

The Best solution-

Pivot Table - Formulas - Calcuated Fields - type in " =IF(SUM(' Days2')>=3,SUM(' Days2'),0)"