How to change data range for Pivot Table

P

piotr.kabath

Hi,

How can I make pivot table query for parameters like data range, I have
done something like this in normal query by adding [Ask For Date:] in
MS Query.
Does anyone know how to achieve similar result for Pivot Table.

regards
Peter
 
D

Debra Dalgleish

You can use the pivot table's page fields to filter the data. Or, import
the external data to a worksheet, where you can use parameters, and base
the pivot table on that.

Hi,

How can I make pivot table query for parameters like data range, I have
done something like this in normal query by adding [Ask For Date:] in
MS Query.
Does anyone know how to achieve similar result for Pivot Table.

regards
Peter
Click to expand...
 
K

Ken Wright

Personally I usually add another field to my source data. I put in a couple
of dates in some helper cells, ie a start and a finish date, and then put a
formula into the additional field that compares the date value for each
record in the source data to the two dates I have entered in my helper cells,
and have it return TRUE/FALSE or INCLUDE/EXCLUDE (Anything that makes sense
to you), and then just drag that field into the page fields. makes it very
easy to define date ranges then.
 
P

piotr.kabath

But do you acctually pass parameters to query ?
Becouse I wish to reduce amount of data being tranfered.

regards
Peter
 
Top