Forum Discussion
link columns
Is that how your current data is stored? What can you tell me about the related table? What does the desired result look like?
Is that how your current data is stored? What can you tell me about the related table? What does the desired result look like?
I have 2 tables, the one that I sent you and another one where each bill is written by supplier.
The link between both tables are the month, the year, and country.
The problem is : I have a pie chart where pickles, bun, steak, cheese are stored and a graph where we can see how many burgers we have sold by month.
So, for example, when I click on pickles for january, I can see that I have sold 100 burgers but in reality, I only need 80 pickles so I want to show that I only used 80 pickles.
Alright I understand your data structured now. I also understand your pie chart and burger graph. See the picture below for what I have so far.
Now I'm trying to understand where you click on pickles. In the table or on the pie chart? I'm still trying to figure out, where you want the 80 pickles to be displayed?
Hi Anonymous,
I am sorry if it is not clear but I am going to try to explain myself in details.
I have 2 tables : one with my burgers sold (by month in one hand, in the other hand how many pickles I used) and one with all data about suppliers (date of purchase, how much, what country made the purchase, kind of purchase, etc.).
I created a relation between my 2 tables with '&' between countries and date.
I have a pie chart where my kind of cost are stored (pickels, cheese, etc.) and I have a histogram where I can see how many burgers I sold by month.
When I click on pickels, I want to see how many I used for real. Now, I am only able to see, that when I have a bill with the date of purchase, that 100 on a 100 burgers sold have pickles on. In fact that is not true, so I want to use my 'pickles I used' column but it does not work because it creates another column on my graph as I only want to see how many burgers I sold.
I tried to make myself as clear as possible, I hope you are going to understand what is my concern.
I am sorry but I cannot send screenshot.
Thanks