Pivot tables greater than

**mkvassh** · 12-17-2009, 04:53 AM

Is it possible to just show numbers greater than an amount in a pivot table?

**rwgrietveld** · 12-17-2009, 05:11 AM

Sure,

Easiest is to have an additional column in your table like (e.g. in H2)
=G2>0
This will result in TRUE/FALSE.

This can be used as a 'report filter' in the PT.

**mkvassh** · 12-17-2009, 05:31 AM

I was thinking about the same thing, but I want to base this "greater than" on the total in the pivot table.

This is an accounting report based on a table with a lot of lines, where we have to explain amounts greater than 100.000 on the account level. Accounts can consist of several lines.

**mkvassh** · 12-17-2009, 05:41 AM

I found a solution to this problem, by using Autofilter on the PivotTable. See more details in this link.

http://peltiertech.com/WordPress/autofilter-tricks/