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

2) How to display Highest value in sum(sales) and corresponding Region also.

     i am using Aggr() it show only highest value but not Region 

i attache QVW file also

please give reply...

Thanks

[sunny_talwar]

I think there is no data in your attached app. Can you reload and repost your app?

[Anonymous · Accepted solution]

Best is to do it in the script:

Directory;

LOAD if(Region='Unknown','EAST', Region) as Region ,

     sales

FROM

(ooxml, embedded labels, table is Sheet1);

[ramrongala]

Ok Bro

[ramrongala]

Thanks...working fine