the question is Region has its Subfields so the case study is as below

[sumitjadhav]

R1(Sb1,Sb2,Sb3)=data(1,5,7)

R2(Sb4)=data(9)

R3(Sb5)=data(10)

R4(Sb6,Sb7)=data(7,8)

R5(Sb8)=data(9)

[SreeniJD]

Hi Sumit

Can you please give some more clarity on your question

Sreeni

[sumitjadhav]

please rep me soon....!!!

[sumitjadhav]

i have 3 fields in my main table ie,region,sub_region and data,i want my result in the new field take it as dimension in that i want to show the total of data of sub_regions with the respective Regions.

[SreeniJD]

use the calculated dimension as =AGGR(sum(data),sub_region,region)

[sumitjadhav]

i want this output by using backend by using scripting not at frontend

[sumitjadhav]

tell me the same procedure to implement it on backend

[sumitjadhav]

I WANT OUTPUT LIKE THIS

dim   Data

SB1     1

SB2      5

SB3      7

R1      13

SB4      9

R2      9

SB5      10

R3      10

SB6      7

SB7      8

R4      15

SB8      9

R5      9

[sumitjadhav]

i got the solution for the same please check it once

table1:

LOAD * INLINE [

    Region, Sub_Region, data,code

    R1, Sb1, 1,1

    R1, Sb2, 5,1

    R1, Sb3, 7,1

    R2, Sb4, 9,2

    R3, Sb5, 10,3

    R4, Sb6, 7,4

    R4, Sb7, 8,4

    R5, Sb8, 9,5

   ];

new:

LOAD

*,

//Region&'_'&Sub_Region as Dimension,

subfield(Region&'_'&Sub_Region,'_') as dim

Resident table1;

[sudeepkm]

I'm not sure If I understand your question. Are you trying to group the data by Region?

In that case you can use group by clause doing a resident from the existing table.