How to select range of values in pivot table?

R

RADO

Hi all,

How can I programmatically show a range of data in a pivot
table to display? I can easily display top 10 or bottom 10
etc data points, but how to diplay a specific range?

I have a simple pivot table in Excel 2002 - row field is
various computer systems, and data field is their CPU
speeds, ranging from 100 Mhz to 4000 MHz.

I need to display only certain range of data - say, CPUs
with speeds between 1000 and 2000 MHz. Any ideas how to
accomplish this?

Thanks -
Andrei
 
B

BrianB

Make a new column in your base data for this information and use a
page field in the pivot table.

Regards
BrianB
===================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Changing pivot table ADO recordset 0
Pivot table 0
Macro to update pivot table data range 3
create a pivot table and chart from a named range 1
Pivot Tables - Multiple Ranges 9
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Selecting Date Range in a Pivot using VBA 0

Top