Thanks Laurent,
I tried that, but I can't get it to work, as it just returns
all the
data again. If I have in one row of data only one of the 24
months
where the value should be excluded, how can I make only that
cell
"blank" or "zero" and leave the other
months intact? I would not want
the advanced filter to exclude the whole record, but just
one of the 24
values in that record.
Regards.
Andre
-----Original Message-----
From: Laurent
Sent: Tuesday, 17 April 2007 10:24 AM
Why not use the advanced filter?
Create a criterion range, filter to another location, then
use new
location as the source for the pivot table Obviously, if you
have 24
months, then you'll need an "or" construct - 1
line per month
L
-----Original Message-----
From: Andre Wium
Sent: Monday, 16 April 2007 1:59 PM
Thanks Darryl,
In my case your proposal won't work, because I have many
monthly columns
(24) to include in the pivot, and I cannot create an
include/exclude
flag for each month. I would like the pivot to ignore any
amount below
a certain value, no matter where in the data range such low
values
appear. But thanks for the hint.
Regards.
Andre
-----Original Message-----
From: Darryl Collins
Sent: Monday, 16 April 2007 12:38 PM
A quick and dirty way would be to add in an extra field
(column) that
returns a flag if your criteria is met, and then you can
only show the
flagged data in the pivot table.
Naturally i am sure there is a more tidy way of doing this,
but hey...
regards
Darryl
-----Original Message-----
From: Andre Wium
Sent: Monday, 16 April 2007 12:24 PM
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 webmaster roche.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
|