Hi there,
I've run into something for which I did yet not find a satisfactory solution.
I've a sheet with data, say: 3 main categories, which are subdivided, which are again subdivided. Then at the lowest level, I will have a column stating if that certain attribute is 'done'.
example_rawdata.PNG
Now I'll make a pivot table from this in order to have the collapse/uncollapse feature:
example.PNG
Now I want in the pivot table the colour be determined by its status as I have done manually in the picture above. For the lowest level this is easy, rule: =D4:D40="Done" and applied to: =C4:C40.
However, for the column 'sub' this is less straightforward, since the current lay-out is greatly simplified and I want it to be dynamically changing when I add or omit new entries.
The goal of this table is to easy have an overview of which attributes are not 'done', since this list will contain around a 500 attributes. Even when I collapse a level of detail.
Is there someone here with a smart solution to my problem? Any help would be greatly appreciated!
Bookmarks