Hi Expert,
I have a challenge in completing Sunburst Chartfor one my dashboard and I am stuck… browsed thru onlnsomesolutions but somehow I am unable to figure it out. So seeking expertadvise.
I have created 3 layer Sunburst Chart, my 3rd Layer (outer layer) hasthe value in Excel sheet. I want to show overall value (total of 3rdlayer) in 2nd layer (mid layer) and 2nd layer value in 1stlayer (inner layer).
Eg: I have 4 columns, Now my Outlayer (month) should show values of each month, midlayer should show Q1 total value of months (Jan+Feb+Mar) and inner layer shouldshow total of Q1 & Q2.
Years | Qtr | Month | Value |
2018 | Q1 | Jan | 5% |
2018 | Q1 | Feb | 5% |
2018 | Q1 | Mar | 5% |
2018 | Q2 | Apr | 6% |
2018 | Q2 | May | 6% |
2018 | Q2 | Jun | 6% |
<tbody>
</tbody>
Regards,
Harish S