View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Pivot Table Value Filter

Hi Todd

One suggestion, but it might not be a layout that you like, would be to
drag the dollar value field to the Row (or Column)
area, as well as to the Data Area.

In the Row area, highlight the field and Right click
Groups and Show DetailGroupStarting value$£2mchoose an appropriate
unit for By
--
Regards

Roger Govier


"T. Jenkins" wrote in message
...
I'm trying to filter a pivot table to only process entries above a
certain
dollar value. For example, I only want to act on data above $2M.

I know I could do this by sorting the original data by dollar value,
then
only selecting records meeting my filter criteria, but I was hoping to
do
this within the Pivot.

Any suggestions?

Todd