I have the following input table, in which I have sales for Nation, Region and its respective territories. I need the output in the following format: (Here I will add a filter of territory, so depending on which territory is selected it will show its sales, it respective regions sales and nation sale in one table. Also, the respective contribution of territory in that region, and contribution of region in Nation.)
Only Territory column can be filtered and selected.
territory Is subset of region
Region Is subset of Nation
So there will be a filter for Territory and yes it needs to be shown like above output only. Like T and R and N, depending on which territory gets selected in filter, its respective region will be shown