Another Method i mean in UI also u can implement this just by at the stage of selecting dimensions just click on Add Calculated dimension and do following
for example : Branch&'-'&SalesPerson
here the separator is ''-''
RawData:LOAD * INLINE [
Doc ID, Name, Marks
112, a, 21
112, b, 22
134, c, 34
135, d, 33
135, a, 44
Data:LOAD [Doc ID],
[Doc ID]&'-'& Name As Doc_Key,
DROP Table RawData;
Take a chart..Dimension : Doc_Key
Exp : Sum(Marks)
Simply by making that dimention composite key.
your 1st dimention that you want to combine is a
your 2nd dimention that you want to combine is b
then in load statement
a &'-'& b as Key,
if u want to use two dimension mean and also u want to see the data in each dimension wise mean use
cyclic or drill down group or else combine the 2 field using and like this a '&' b as key in script
Sorry dear by mistake i didnt get you.
You can do it only with script.
if you used cylic grioup or drill down yet you see the dimention seperately.
Alternative is that like
a &'-'& b as key
By this your both a and b will combine as kay also a and b are seperately like past.
if((Group_Discharge <=40)<=(Group_Load<=40), Group_Load & ' <-> ' & Group_Discharge )
This is the code i'm using.
I need to combine two dimension and sum the data together to become only one column. Hope you all got what i mean.