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]

(http://www.vbaexpress.com/forum/PT0014%20-%20Filter%20from%20Worksheet%20Date%20Range%20--%20Enter%20start%20and%20end%20dates%20on%20the%20worksheet,%20and%20update %20the%20pivot%20table,%20to%20show%20matching%20items.%20PivotDateRange.zi p%2017kb%20%20%20%2010-Mar-07)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 (http://www.contextures.com/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.