Below is my current workaround for activating filters for a pivot table. It works great as long as that value exists in the pivot table, otherwise it errors out. I need to either activate the last five business days, and if one doesn't exist skip, or activate the last five business days that do exist. Either way.
Please Login or Register to view this content.
It would help a lot with a sample file with representative data. In most cases, it's difficult to answer pivot table questions without seeing how the source data are organized.
Also the way I check to see if an item is available for filtering is to do a COUNTIF on the column. If it comes up zero, I can't filter on it.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Attached is a general idea. The macro puts the formula into P1:T1 and the pivots look to that to see if it can enable a filter. Issue is, if there is no item with that date the pivot will error out. If it would skip the date then that would be ok too.
Hey dflak, any idea?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks