Clever Geek Handbook

Is there a report type or cross-tab that displays this data elegantly?

I have data in this form,

Article ID  Company A   Company B   Company C
1            Featured    Mentioned   --
2            Mentioned   Featured    Mentioned
3            Mentioned   --          --
4            Featured    Mentioned   Mentioned
5            Mentioned   Mentioned   Featured

Id like to show, for example, how many times Company B was mentioned in an article where Company A was represented. I can write a manual query to answer this question, however I thought it might be a more elegant way to show the counts in the grid all combinations. Then someone could see how many times Company C was mentioned in an article that featured Company A or B, and vice versa.

Does anyone have any suggestions on how to approach this? I just don't feel creative today and all I can think of is a lame, brute-force, manual method;)

+1


source to share


1 answer


If you could add a drop-down filter for each column, such as an AutoFilter in Excel, users could select "Mentioned" for Company A and "Featured" for Company B, and the number of rows displayed would answer the question "how many."



+2


source






More articles:


All Articles