How to combine 2 values in dimension

[ramrongala]

Hi All,

I want add 2 values into single value in dimension.

1) Here 5 values(EAST,North,South,Unknown,West) are

there but i want add 'Unknown' and 'EAST' into  single value like 'EAST'  then sum of sales also automatically show single value right.how to combine

i attache QVW file  and Excel file also

please give reply...

Thanks

[vishsaggi · Accepted solution]

Try this?

LOAD

IF(Match(Region, 'Unknown'), 'EAST', Region) AS Region,

sales

FROM

(ooxml, embedded labels, table is Sheet1);

[ramrongala]

Thanks...working fine