2 Replies Latest reply: Aug 21, 2018 11:06 PM by Manoj Kumar M R RSS

    Stacked bar chart from 2 tables

    Manoj Kumar M R

      Hi Guys,

       

      I need to create a stacked bar chart from the information available in two tables (Sales and target remaining). Stacked bar chart should be like below, x axis is sales month with sum(sales) in the y axis and stacked with target remaining which is available in remaining target table. linking key is ID column.

       

        Sales:  

      IDSalesSale month
      1200Jan
      1150Feb
      2300Feb
      375Jan
      350Feb
      325

      March

       

      Remaining Target:

         

      IDTarget remainingTarget month
      1150Jan
      2100Jan
      3200

      March

       

       

       

      Stacker Bar chart: