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?
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?