I think the first step we need to do is to create a hierarchy of Part Number > Worldwide Customer Name > Sold to Name. This will allow for the drill down/up functionality.
Next, after fully expanding the hierarchy, go to the Analysis menu > Totals > Add All Subtotals. From Totals menu you can also enable the 'Column Totals to Top' option so that the viz looks like your sample screenshots. Hope this helps!
Hi Dan Sanchez,
Thanks a ton for your response!
I have already created a table with drill through option. I want to show this numbers graphically, hence seeking experts help about any other charts/graphs which are interactive and can be used to show this analysis.