I have a pivot table wherein two of my row fields used are "Date" and
"Description." I would like to limit the pivot table information displayed
to a certain range of dates (which i do now by selecting/deselecting the date
check-boxes in the date field dropdown), and then if possible...and here is
my question, further limit my data using the "Description" field...is there a
way to have the "description" field drop-down only display discriptions that
fall within the date range I have already selected? As it is now, all of the
descriptions are displayed in the description drop-down even if they pertain
to dates i have deselected.