I have a chart which plots share of products in a market. but here i want to plot a static trend line which consists total market value.
basically I have 2 sql tables. PRODUCT and MARKET.
using PRODUCT table to plot the chart.
but total market value field is present in MARKET table.
now how can i plot total market value from 2nd table(MARKET) ?