-
1. Re: Dynamic Table Headings Linked to Selected Values in Filters
Tracy RodgersMar 6, 2012 11:32 AM (in response to Perry Chung)
1 of 1 people found this helpfulHi Perry,
If the BU Level 2 field is somewhere on each worksheet, then it will be able to be added to the Title (use the Insert button on the Edit Title dialogue). Then, depending what is selected in the filter will appear in the title. I'm not sure if this is what you're looking for, but I hope it helps!
-Tracy
-
2. Re: Dynamic Table Headings Linked to Selected Values in Filters
Perry Chung Mar 6, 2012 2:14 PM (in response to Tracy Rodgers)Thanks Tracy, it worked. I had to put an Index formula as one of the filters.
When I select a value in the filters, the title change in the respective worksheet, however all the other titles changed to "Null". Would you know how to set the titles of the other tables so that if the option is selected in the filter, they will become blank?
Cheers
Perry
-
3. Re: Dynamic Table Headings Linked to Selected Values in Filters
Tracy RodgersMar 6, 2012 2:19 PM (in response to Perry Chung)
I'm glad it worked! To get the titles to show blank, you could possibly created calculated fields and put it on each worksheets?
If [BU Level 2]='City A' then 'City A' else ' ' end
I think a calculated field would need to be created for each worksheet. I think this should work, I hope it does!
-Tracy