100% stacked bar chart-logic
Hi Team,
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 | A | 2017 | 12,997,884.92 |
| Bank | C | 2017 | 119,007,762.71 |
| Bank | I | 2017 | 135,739,186.23 |
| Bank | I1 | 2017 | 0 |
| Bank | S1 | 2017 | 1,191,142,707.09 |
| Bank | S2 | 2017 | 104,908,789.70 |
| Bank | S3 | 2017 | 2,540,652.93 |
| Bank | A% | 2017 | 0.008298269 |
| Bank | C% | 2017 | 0.07597839 |
| Bank | I% | 2017 | 0.08666027 |
| Bank | I1% | 2017 | 0 |
| Bank | S1% | 2017 | 0.760463885 |
| Bank | S2% | 2017 | 0.066977152 |
| Bank | S3% | 2017 | 0.001622035 |
| Bank | Drop-ins | 2017 | 5,499,575.25 |
| Bank | New Business % | 2017 | 0.996501179 |
| Bank | Drop-ins % | 2017 | 0.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.
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%.
Nov 17, 2018 6:17 PM
