Union or case statement on a dimension at report level

[#1]

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