0 Replies Latest reply on Nov 11, 2018 12:20 AM by Shashank Chandra

    stacked bar chart with multiple lines showing weighted average at different level

    Shashank Chandra

      HI All,

      I am struggling to get a stacked bar chart with multiple lines that show weighted average at different levels.

        

      Var1Var2Var3ABFreqSumWt average based on freq and sum
      AA1A1247x5
      AA2A2158x5
      BB2B2199x5
      BB2B2160x5
      CC1C1363x5
      CC1C14645x5
      CC3C3525x

      What i want is a stacked bar chart which will show the sum of A & B at different levels od Var1, var2 and Var3 and will also show the weighted average calculated at var1 , var2 and var 3 levels simultaneously in form of line chart. i have tried multiple ways like using LOD expression, pivoting the columns, but nothing works.

       

      Thanks