Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this output based on certain selection or do you always want to see T1, R1, and N?
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