I have two problems with visualizing my data. Can you please give some advice. I have journal entry data where one entry has many positions (rows). For example:
JE ID | amount | account | supplier | Cost center 1 | 100 | V | S1 | 1 | -100 | A | | C2 2 | 50 | V | S1 | 2 | 50 | V | S2 | 2 | -100 | A | | C1 3 | 100 | V | S3 | 3 | -40 | A | | C1 3 | -60 | A | | C2
1) I want to plot a bar plot with supplier and amount. But when I click on a bar and click on "view details" I want to see all positions of the JEs involved. Say, when I click on "S3" I want to see
3 | 100 | V | S3 | 3 | -40 | A | | C1 3 | -60 | A | | C2
and not only the fist line. At the moment I achieved that by loading a second table with the suppliers only and link that table to the first table. This work-around has to problems. Fist, my data is more complex than the example and I do not want to load a new table for each column. Second, if I link the column in this way, then I cannot sort by suppliers. Is there another way to realize this?
2) I want to visualize the connection between suppliers and cost centers. But if I read the table row by row then all suppliers are linked to Null and Null is linked to all the cost centers. Here I could either write the supplier in all row, which would double some entries and then the detail view is wrong - or I could again use a second table and link it, which has the same problem as above.
Do you have any idea how to solve this? I would appreciate any comment.