Re: PivotTable custom "Show Top..." filter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

How about using the macro recorder in Excel? Turn it on, hook up your pivot
table and filter on your criteria. When you are done, have a look at the VBA
script that the macro recorder generated and port it to your code. That's a
sure-fire way to get what you want.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


"Paul Skelton" <rpskelton2@xxxxxxxxxxx> wrote in message
news:%237p3wzYjGHA.3496@xxxxxxxxxxxxxxxxxxxxxxx
I took a look at the FilterFunction but unless I'm missing something it
doesn't look like that will work. I only want to show rows that have a
value > 1,000.

Microsoft.Office.Interop.Owc11.PivotFieldFilterFunctionEnum only contains
Count, Percent, and Sum options - none of which are what I am looking for.



Thanks!


"Alvin Bruney [MVP]" <www.lulu.com/owc> wrote in message
news:OPJLEOXjGHA.3780@xxxxxxxxxxxxxxxxxxxxxxx
Yup, you can use the filterfunction method to filter by a top number of
quantities.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


"Paul Skelton" <rpskelton2@xxxxxxxxxxx> wrote in message
news:%23O7gvj%23iGHA.4504@xxxxxxxxxxxxxxxxxxxxxxx
I've worked with OWC quite a bit and know how to add custom menu items
but I'm not sure how the PivotTable implements the "Show only the top
10", 25, 25%, etc. What I'd like to do is have my custom menu implement
a filter that does something like "Show values > 1,000". Is there some
programmatic way to perform the same sort of filtering that the
PivotTable does with the "Show only top / bottom" menus?









.

Relevant Pages

  • Re: PivotTable custom "Show Top..." filter
    ... different than the Excel pivot table. ... pivot table and filter on your criteria. ... www.lulu.com/owc, Amazon ... Blog: http://www.msmvps.com/blogs/alvin ...
    (microsoft.public.office.developer.web.components)
  • Re: Moving home
    ... command with multiple arguments. ... to turn on the macro recorder, apply the filter and set the conditions. ... Using the macro recorder to build complex commands is smart. ... "Robert Couchman" wrote in message ...
    (microsoft.public.excel.programming)
  • Re: How to select a range based on values in 1 column
    ... Use the autofilter to filter on column C. ... do it manually with the macro recorder on, then turn it off and check the ... If you copy a filtered range, only the visible cells are copied. ... > of 2 so that I could grab the data associated with it and dump it ...
    (microsoft.public.excel.programming)
  • Re: GetTcp6Table functionality on pre-Vista?
    ... I am afraid the only way to get it in XP is to filter \Device\Tcp6 device. ... Volodymyr, blog: http://www.shcherbyna.com/ ... (This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.win32.programmer.networks)
  • Re: how to program a filter for a three week look
    ... The easy way is to turn on the macro recorder. ... Then create a filter which filters tasks within a certain range. ... Dim lastMonday, threeWeeksLater as Date ...
    (microsoft.public.project.vba)