Select date in page field

[rajesh nag]

Hi,

I have created pivot table, where in the page field if a select a date i should be able to see the report of previous day, selected day and the next day. can any one help me onthis

i have attached a sample data file.

Regards,
Rajesh.

[Bob Phillips]

I am not sure what your problem is? What can't you do with the pivot?

[david000]

This file shows how to create a range of dates for a pivot table.

You will need to create a new column in your data to accommodate a formula that can evaluate you criteria.

I think this is a good way to go, because it avoids the problem of the first day where there is no previous day which can lead to an error.


http://www.contextures.com/excelfiles.html#Pivot


PT0014 - Filter from Worksheet Date Range-- Enter start and end dates on the worksheet, and update the pivot table, to show matching items. PivotDateRange.zip 17kb 10-Mar-07

[rahullambe]

Hi Rajesh I got you..

where do u want to do updates in your Raw counts file or in Sheet 1?

r u from Nagpur?

[rajesh nag]

Hi Rahul,

I am from bangalore i need it in sheet1.

thanks in advance.