How to create a pivot with filter criteria?

Hello all,

Is it possible to create a pivot that will only report data
falling in a
specific range?  E.g. I want the pivot to disregard (or not
include in
the sum) any data lines where the amount is less than a
specific value.

Thanks for any advice.


Andre Wium
Systems Accountant
Commercial Services - Open Cut
Roche Mining
 
Ph: 07 3026 6513 / Mob: 0406850486
 
104 Melbourne Str, South Brisbane, 4101, Queensland



************************************************************
************************************************************
****************************************
The information contained in this email communication may be
confidential. You should only read, disclose, re-transmit,
copy, distribute, act in reliance on or commercialise the
information if you are authorised to do so. If you are not
the intended recipient of this email communication, please
notify us immediately by email to webmasterroche.com.au or reply by email direct to the sender
and then destroy any electronic or paper copy of this
message. Virus protection procedures are in place at Roche
Mining but we do not warrant that this email is virus free
and recommend that the recipient undertake their own virus
detection measures.
************************************************************
************************************************************
****************************************

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G