Anyone ever seen a widget or know the php to do the following?
It's about taking a set of posts from one category and breaking them down by another
On my blog I have a set of categories relating to location and another by industry. I have a different pages dedicated to each industry (I only look at 4) and on these pages only posts tagged with that particular industry are displayed using postlist.
In the sidebar I would like to be able to break down an industry by location. For example the page might show posts in category software, then in the tool bar in the right you could select to show posts about software only by a particular country category. The sidebar would be a menu showing only the country categories that had been used in different software posts.
Is there a widget to do this already? Otherwise, I don't think the php to do this is too tricky and you could even put into the widgets that allow you to enter inline php.