This content has been marked as final. Show 2 replies
I have dataset like this:
|Channel||Measure Names||Year||Measure Values|
|Bank||All VA Premium||2017||1,571,836,558.83|
|Bank||New Business Total||2017||1,566,336,983.58|
|Bank||New Business %||2017||0.996501179|
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.
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%.