Hi tried this. It worked partially.
For a country it is only showing 2 trunk groups on map but if we build a pie chart it is showing all trunk groups for a counrty.
Please find attached screenshots of the same.
Please help me what can be done to overcome this.
Please attach workbook here.
Is it same across countries or only in case of Argentina? Do you have all Term Trunk Group for Argentina or Argentina has onlypeer-kddi and peer-tata in your source data? Just validate with your data. Or as Shankar has said share the workbook that'll be more helpful for us to give you the desired solution.
I checked after posting the question.. on changing the hierarchy the data came out to be as desired.
Thank you so much
Thank you.. I got the desired output