2 Replies Latest reply on Nov 17, 2018 6:33 PM by Shinichiro Murakami

    100% stacked bar chart-logic

    DHRITIMAN BANERJEE

      Hi Team,

       

      I have  dataset like this:

         

      ChannelMeasure NamesYearMeasure Values
      BankAll VA Premium20171,571,836,558.83
      BankNew Business Total20171,566,336,983.58
      BankA201712,997,884.92
      BankC2017119,007,762.71
      BankI2017135,739,186.23
      BankI120170
      BankS120171,191,142,707.09
      BankS22017104,908,789.70
      BankS320172,540,652.93
      BankA%20170.008298269
      BankC%20170.07597839
      BankI%20170.08666027
      BankI1%20170
      BankS1%20170.760463885
      BankS2%20170.066977152
      BankS3%20170.001622035
      BankDrop-ins20175,499,575.25
      BankNew Business %20170.996501179
      BankDrop-ins %20170.003498821

       

      In the datset, ALL VA premium is calculated from addition of A+C+I+I1+s1+s2+s3+drop-ins and new business total is calculated from A+C+I+I1+s1+s2+s3.

      Drop-ins is calculated from ALL VA premium-new business total,new business% is calculated from new business total/all va premium and drop-ins% is calculated from dop-ins/new business total.

       

      I want to show a 100%  stacked bar chart which will show new business%and drop-ins% for bank channel . I have calculated the 100% stacked bar for the products for reference.

      100% stacked bar.PNG

       

       

      I need a logic where I have to show new business% and Drop-ins% like this . New buisness% contains all products with its premium except drop-ins and drop-ins contains  drop-ins product.

      How to include new business % and drop-ins% in the chart. for ex : Bank channel for 2018 will show new business % of 80%and drop-ins % of 20%.