PDA

View Full Version : Select date in page field



rajesh nag
09-25-2008, 03:03 AM
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
09-25-2008, 03:17 AM
I am not sure what your problem is? What can't you do with the pivot?

david000
09-25-2008, 12:07 PM
(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
09-25-2008, 12:12 PM
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
09-25-2008, 07:03 PM
Hi Rahul,

I am from bangalore i need it in sheet1.

thanks in advance.