![]() |
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