View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
erick-flores erick-flores is offline
external usenet poster
 
Posts: 9
Default Pivot Table question



In the pivot table, add the new field to the Page area, and select TRUE
from its dropdown list.


Thanks for your reply, but let me see if I get this right
1. You could add a field to the source data, to calculate if the
record
should be shown in the pivot table.

So I need to add a new field to my table, right? with no data on it,
just an empty field. And then add this field to the DATA part in my
PivotTable.

2. =AND(A2=StartDate,A2<=EndDate)
Where do I put this function? in the field that would be in the DATA ?
how do I write a function in there?

3. StartDate and EndDate are named ranges, where the date range could
be
manually entered or calculated.

Need to have two cells where i would be putting my StartDate and
EndDate, I understand that. But how would this be related to my field
that has the period ending?

I am kinda lost in here, if you could please guide me here
step-by-step, Thank you very much