How to change data range for Pivot Table

[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

 

[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

 

[Guest]

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.

 

[piotr.kabath]

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

regards
Peter