Need help in creating output table

[Anonymous]

Hi All,

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.)

    OutPut

Area	Sales	% Contribution
T1	119	11%
R1	1,126	41%
N	2,749

The input table is:

Input
Nation	Region	Territory	Sales
N	R1	T1	119
N	R1	T2	116
N	R1	T3	164
N	R1	T4	198
N	R1	T5	137
N	R1	T6	110
N	R1	T7	124
N	R1	T8	158
N	R2	T9	140
N	R2	T10	200
N	R2	T11	119
N	R2	T12	127
N	R2	T13	186
N	R2	T14	107
N	R2	T15	174
N	R2	T16	198
N	R2	T17	141
N	R2	T18	118
N	R2	T19	113

Appreciate your help.

Thanks

[sunny_talwar]

Is this output based on certain selection or do you always want to see T1, R1, and N?

[Anonymous]

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