Hi,
In the attached workbook I have made an example of a workbook I and other work with quite frequently. However, the workbook is quite big and contains a a lot more headers. When looking over another workbook I saw that the filters for dates had subcategories i.e year - month - day, and I wondered if it was possible to either keep the table as it is and use the date filter for other categories such as text or numbers or if there are any suggestions of how to maybe reformat the table for easier use and filtering.
The header "project" is a perfect example - right now it is only a formula dictating what row is what project, optimally you could choose this as a subcategory in another column filter i.e in the Number filter numbers 1-99 would have the category Project A and under categories would be the actual numbers 1-99.
I have experimented some with Pivot Charts but I could not format one to make them look any more clear than just a regular table.
Bookmarks