Re: 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 Detail>Group>Starting value>$£2m>choose an appropriate
unit for By
--
Regards

Roger Govier


"T. Jenkins" <TJenkins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:35912EA2-382A-427A-944C-0B63ECC8DF56@xxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: True parallel columns in Word
    ... What you are seeking is a page layout solution. ... Thanks for the suggestion. ... rows for each paragraph or a table with a single row spanning multiple pages. ... This post is a suggestion for Microsoft, ...
    (microsoft.public.word.pagelayout)
  • Re: Help Selecting A Function
    ... It will pull all the entities matching the claim number you enter ... (Drag the formula down according to the maximum possible entities per claim. ... Using your suggestion, selecting say B1 to B50, I only want the records ... claim numbers and my second worksheet contains a link file listing ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Counting occurences in a list
    ... Hit that Layout button. ... Drag the header for the date field to the Row field ... You may even want to drag the grey Result box to the right one cell. ...
    (microsoft.public.excel)
  • Re: WMM 2.1.4026
    ... can't drag and drop and if I can't drag and drop I can't control P, ... Any suggestion on how to add a wav file to avi? ... How do I convert other video file formats to WMV? ...
    (microsoft.public.windowsxp.moviemaker)
  • Task Timeline Suggestion
    ... you could click and drag task to tuesday. ... This post is a suggestion for Microsoft, ... Agree" button in the message pane. ...
    (microsoft.public.outlook.general)