Hi,
Here is the output of the report I would like to achieve.
Region column has only values EMEA and NOAM. Region = 'EMEA InsideSales' is a value that I derive when Condition A=1 and ProductGeneration= (4,5) and Region = EMEA and Region = 'EMEA External' when Condition A=0 and ProductGeneration = (4,5) and Region = EMEA.
EMEA ALL is when no filter is applied ( i.e Condition A = (1,0) and ProductGeneration=1,2,3,4,5 and Region = EMEA )..so EMEA ALL is NOT equal to EMEA InsideSales + EMEA External.
Region | QTD Opty Units | QTD Renewal Units |
EMEA InsideSales | 100 | 30 |
EMEA External | 50 | 25 |
EMEA -ALL | 200 | 100 |
NOAM InsideSales | 150 | 100 |
NOAM External | 200 | 160 |
NOAM ALL | 375 | 350 |
Any help is appreciated.
Thanks
Shilpa