Hello from the Netherlands,
I hope you can help me with the following problem I would like to solve:
Every week I receive an Excel datafile that looks like the one in the attachment (but much more elaborate - more than 2000 subject and about 200 different labels). It only exists of two columns, a subject-column and a label-column. As you can see in the example, some labels are related with more then one subject, and most of the subjects are related with more labels.
From these two columns I would really like to make some charts. What I would like are some charts where the relationship between a combination of labels (from the label-column) and the amount of subjects where this combination exists is being shown. For example there are 65 subjects with combination Label1 AND Label2 en 32 with combination Label1 AND Label4. But I would like to provide insight of all possible combinations (I won't show them all, but I'd like the opportunity to choose it).
It's my goal to create weekly a kind of dashboard (with Power Pivot/View)? with for example six or eight charts where I give insight in some relationships between (combinations of) labels and subjects.
Can you give me some advise of the easiest way to handle this?
Bookmarks