Dear All,
I have a chart in which i show brand wise share . When no Region is Selected it shows at All India Level which is correct as per below.
Dimension Expression :=if(getselectedCount(Region)>0,Region,'All India')
Expression Used:
=sum({<LinkCommonDate={">=$(vLast2MonthMinDate)<=$(vLast2MonthMaxDate)" },Year=,Month= >}$(vMeasureSales))/
Sum(TOTAL {<LinkCommonDate={">=$(vLast2MonthMinDate)<=$(vLast2MonthMaxDate)"},CompetitorName=,Year=,Month=>}$(vMeasureSales))
| Region | Brand | Dealer Count | Jul17 | Aug17 | Sep17 | Week38 | Week37 | Week36 | Week35 | Jul | Aug | Sep |
| All India | | 23319 | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 0.0% | 0.0% | 0.0% |
| All India | SAMSUNG | 23225 | 52.0% | 55.5% | 58.8% | 61.2% | 56.9% | 58.9% | 58.2% | 3.2% | 3.5% | 3.3% |
| All India | VIVO | 21177 | 13.2% | 11.4% | 12.3% | 12.7% | 13.9% | 11.0% | 10.9% | -0.4% | -1.8% | 0.9% |
| All India | OTHERS | 21177 | 12.2% | 10.4% | 9.4% | 8.4% | 9.5% | 10.0% | 9.8% | 0.8% | -1.8% | -0.9% |
| All India | OPPO | 21177 | 11.6% | 10.2% | 8.6% | 8.0% | 8.5% | 8.7% | 9.2% | -1.0% | -1.4% | -1.6% |
| All India | APPLE | 21177 | 5.1% | 5.1% | 3.7% | 3.3% | 3.7% | 3.8% | 4.3% | -1.7% | 0.0% | -1.4% |
| All India | GIONEE | 21177 | 3.2% | 2.9% | 2.5% | 2.2% | 2.5% | 2.6% | 2.7% | -0.5% | -0.3% | -0.4% |
| All India | MICROMAX | 21177 | 1.3% | 1.4% | 1.2% | 1.0% | 1.3% | 1.4% | 1.3% | 0.0% | 0.0% | -0.1% |
| All India | LAVA | 0 | 1.1% | 0.3% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | -0.1% | -0.8% | -0.3% |
| All India | LYF | 21177 | 0.2% | 0.2% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | -0.2% | 0.0% | 0.0% |
| All India | HTC | 0 | 0.2% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | -0.1% | -0.1% | 0.0% |
| All India | XIAOMI | 21177 | 0.0% | 2.8% | 3.3% | 3.1% | 3.5% | 3.4% | 3.4% | 0.0% | 2.8% | 0.5% |
Now i want my expression to show Region wise contribution when i drill down on Region :
I want Like below
| Region | Brand | Dealer Count | Jul17 | Aug17 | Sep17 | Week38 | Week37 | Week36 | Week35 | Jul | Aug | Sep |
| EAST 1 | SAMSUNG | 2595 | 53.0% | 56.9% | 59.7% | 60.2% | 58.9% | 60.3% | 59.2% | 2.4% | 3.9% | 2.8% |
| EAST 1 | VIVO | 2366 | 13.1% | 10.4% | 10.7% | 11.5% | 11.3% | 9.8% | 10.0% | -0.3% | -2.7% | 0.3% |
| EAST 1 | OTHERS | 2366 | 11.2% | 11.3% | 11.2% | 10.6% | 11.0% | 11.9% | 11.6% | 0.3% | 0.1% | -0.1% |
| EAST 1 | OPPO | 2366 | 10.8% | 8.8% | 7.5% | 7.6% | 7.6% | 7.0% | 7.6% | -1.0% | -2.0% | -1.3% |
| EAST 1 | GIONEE | 2366 | 6.0% | 5.7% | 5.0% | 4.8% | 4.9% | 5.1% | 5.3% | -0.8% | -0.4% | -0.7% |
| EAST 1 | APPLE | 2366 | 2.4% | 2.4% | 1.5% | 1.2% | 1.6% | 1.5% | 1.7% | -0.4% | 0.0% | -0.9% |
| EAST 1 | MICROMAX | 2366 | 2.1% | 2.2% | 2.1% | 1.9% | 2.1% | 2.3% | 2.3% | 0.0% | 0.1% | -0.1% |
| EAST 1 | LAVA | 0 | 1.0% | 0.3% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | -0.7% | -0.3% |
| EAST 1 | HTC | 0 | 0.2% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | -0.1% | -0.1% | 0.0% |
| EAST 1 | LYF | 2366 | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | -0.1% | 0.0% | 0.0% |
| EAST 1 | XIAOMI | 2366 | 0.0% | 1.9% | 2.3% | 2.2% | 2.6% | 2.0% | 2.3% | 0.0% | 1.9% | 0.3% |
| EAST 2 | SAMSUNG | 2494 | 58.4% | 64.3% | 64.0% | 65.3% | 62.8% | 63.9% | 65.4% | 2.0% | 5.9% | -0.3% |
| EAST 2 | OPPO | 2302 | 11.1% | 8.9% | 8.2% | 7.9% | 8.1% | 8.3% | 8.3% | -0.9% | -2.2% | -0.7% |
| EAST 2 | VIVO | 2302 | 11.0% | 9.0% | 10.3% | 10.8% | 11.3% | 9.3% | 8.9% | -0.4% | -2.1% | 1.3% |
| EAST 2 | OTHERS | 2302 | 10.4% | 9.4% | 9.5% | 9.0% | 9.7% | 9.9% | 9.3% | 1.4% | -0.9% | 0.1% |
| EAST 2 | GIONEE | 2302 | 3.9% | 3.3% | 3.0% | 2.8% | 3.0% | 3.1% | 3.1% | -0.5% | -0.6% | -0.3% |
| EAST 2 | MICROMAX | 2302 | 1.9% | 1.8% | 1.6% | 1.3% | 1.6% | 1.7% | 1.7% | -0.1% | -0.1% | -0.3% |
| EAST 2 | APPLE | 2302 | 1.8% | 1.4% | 1.5% | 1.2% | 1.5% | 1.7% | 1.5% | -0.8% | -0.3% | 0.0% |
| EAST 2 | LAVA | 0 | 1.1% | 0.3% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | -0.1% | -0.8% | -0.3% |
| EAST 2 | LYF | 2302 | 0.3% | 0.2% | 0.2% | 0.1% | 0.2% | 0.2% | 0.2% | -0.4% | -0.1% | 0.0% |
| EAST 2 | HTC | 0 | 0.1% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | -0.1% | 0.0% |
| EAST 2 | XIAOMI | 2302 | 0.0% | 1.3% | 1.8% | 1.6% | 1.8% | 1.9% | 1.7% | 0.0% | 1.3% | 0.5% |
But what i m getting is Example: Bifercation of 52.0 % of Samsung from All India( chart 1st) .In East 1:- 4.2, East 2:- 4.3 so on which is wrong .
Please help .
| Region | Brand | Dealer Count | Jul17 | Aug17 | Sep17 | Week38 | Week37 | Week36 | Week35 | Jul | Aug | Sep |
| - | - | 23319 | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 0.0% | 0.0% | 0.0% |
| EAST 2 | SAMSUNG | 2494 | 4.3% | 4.4% | 4.0% | 4.0% | 3.9% | 4.1% | 4.4% | 1.0% | 0.1% | -0.3% |
| NORTH 3 | SAMSUNG | 2680 | 5.9% | 6.1% | 5.7% | 5.6% | 5.1% | 6.1% | 6.4% | -0.2% | 0.2% | -0.3% |
| WEST 4 | SAMSUNG | 1346 | 2.4% | 3.0% | 2.8% | 2.8% | 2.5% | 2.8% | 2.9% | 0.8% | 0.6% | -0.2% |
| NORTH 2 | SAMSUNG | 1924 | 3.6% | 4.0% | 3.9% | 4.5% | 3.4% | 3.8% | 4.0% | -0.2% | 0.3% | -0.1% |
| NORTH 1 | SAMSUNG | 2037 | 4.5% | 4.9% | 4.9% | 5.4% | 4.6% | 4.6% | 4.7% | -0.2% | 0.4% | -0.1% |
| NORTH 4 | SAMSUNG | 1473 | 3.7% | 3.9% | 4.2% | 4.3% | 4.0% | 4.2% | 4.3% | 0.2% | 0.2% | 0.2% |
| WEST 2 | SAMSUNG | 1600 | 3.9% | 4.6% | 5.0% | 6.1% | 4.9% | 4.3% | 4.1% | 0.5% | 0.7% | 0.2% |
| WEST 1 | SAMSUNG | 2939 | 8.8% | 9.3% | 9.7% | 9.9% | 9.9% | 9.3% | 9.0% | 0.1% | 0.5% | 0.3% |
| SOUTH 3 | SAMSUNG | 1344 | 3.0% | 3.2% | 3.5% | 3.8% | 3.4% | 3.4% | 3.4% | 0.3% | 0.3% | 0.3% |
| SOUTH 2 | SAMSUNG | 1295 | 3.5% | 3.8% | 4.0% | 4.1% | 3.9% | 4.1% | 3.9% | 0.1% | 0.3% | 0.3% |
| EAST 1 | SAMSUNG | 2595 | 4.2% | 4.7% | 5.7% | 6.0% | 5.8% | 5.5% | 5.3% | 0.3% | 0.5% | 1.0% |
| SOUTH 4 | SAMSUNG | 542 | 1.3% | 1.8% | 2.6% | 2.0% | 2.2% | 3.0% | 3.1% | 0.1% | 0.4% | 1.1% |
| SOUTH 1 | SAMSUNG | 956 | 2.9% | 1.9% | 3.1% | 2.7% | 3.1% | 3.8% | 2.8% | 0.3% | -1.0% | 1.1% |
| | | | | | | | | | | | |
