Hello,
I would like some help and suggestions on how to design my link table. This is my scenario
I have table 1 which is expected sales by month and this has the fields Month, Year, Product Line and expected sales. Table 2 is a customer table which has month, product line and actual amount brought for that month. What can be combined together is month, year and product line from both tables.
I would like to create a one chart that so when the user selects a product line a and year the chart displays the expected sales amounts, actuals by customers by month for that year . So the X axis is Month and below the X axis I would like the customers in different colours all plotted on one chart the Y axis is expected and actual amount.
I know Will does not support two dimensions in a chart so how would I do this? Thank you