Pivot Table help
 

Is it possible to filter out information in a Pivot table range before you
actually look at pivot table compiled data?

I have a table that looks at a years worth of data (A4:W10000) as a whole
and filters out certain data based on criteria (Quote Number, Job Name,
etc...). I have two date columns (Date in and Date out) in the main source
data but I do not include a date field in the pivot table.

I would like to use the date out information to restrict the pivot table
data pulled in to only the information of the past 30 days. Is this possible?

thanks
Peter

Pivot Table help
 

hi
why don't you insert date field in pivot
you can group the date field and can have desire reports

--
hemu


"Looping through" wrote:

Is it possible to filter out information in a Pivot table range before you
actually look at pivot table compiled data?

I have a table that looks at a years worth of data (A4:W10000) as a whole
and filters out certain data based on criteria (Quote Number, Job Name,
etc...). I have two date columns (Date in and Date out) in the main source
data but I do not include a date field in the pivot table.

I would like to use the date out information to restrict the pivot table
data pulled in to only the information of the past 30 days. Is this possible?

thanks
Peter

Pivot Table help
 

The PT will not let me add a seventh data field to the table and the other
six fields are more important than the date out.

Any thoughts
Peter

"Hemant_india" wrote:

hi
why don't you insert date field in pivot
you can group the date field and can have desire reports

--
hemu


"Looping through" wrote:

Is it possible to filter out information in a Pivot table range before you
actually look at pivot table compiled data?

I have a table that looks at a years worth of data (A4:W10000) as a whole
and filters out certain data based on criteria (Quote Number, Job Name,
etc...). I have two date columns (Date in and Date out) in the main source
data but I do not include a date field in the pivot table.

I would like to use the date out information to restrict the pivot table
data pulled in to only the information of the past 30 days. Is this possible?

thanks
Peter

Pivot Table help
 

hi
i dident get u
i am using pivot table with around 18 fields

--
hemu


"Looping through" wrote:

The PT will not let me add a seventh data field to the table and the other
six fields are more important than the date out.

Any thoughts
Peter

"Hemant_india" wrote:

hi
why don't you insert date field in pivot
you can group the date field and can have desire reports

--
hemu


"Looping through" wrote:

Is it possible to filter out information in a Pivot table range before you
actually look at pivot table compiled data?

I have a table that looks at a years worth of data (A4:W10000) as a whole
and filters out certain data based on criteria (Quote Number, Job Name,
etc...). I have two date columns (Date in and Date out) in the main source
data but I do not include a date field in the pivot table.

I would like to use the date out information to restrict the pivot table
data pulled in to only the information of the past 30 days. Is this possible?

thanks
Peter