ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Fields (https://www.excelbanter.com/excel-discussion-misc-queries/46537-conditional-fields.html)

DaveCPA

Conditional Fields
 
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.




All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com