Roll up of data

building reports desktopintelligence
1

hi,
i have a problem where i cant roll up the data from the same column in the sense, this is what i have

Operation Quantity Loss
1 2 1
1 3 0
1 4 1
2 4 2
2 5 1

and this is what i want

Operation Quantity Loss
1 9 2
2 9 3

i tried many options :frowning: , but somehow it wont group. The columns Quantity and Loss are from an aggregate table while operation is from a regular table joined to the aggregate table

souvida :us: (BOB member since 2004-05-10)

2

Is you col 1 object is a dimension and col2 and col 3 objects are measures ?

JaiGupta (BOB member since 2002-09-12)

3

all are dimensions.
quantity - agg dimension
loss - agg dimesion
operation - regular univ dimension

and i have 36 different operations which causes the problem.

so what i am trying is for the same operation, instead of having 2 or 3 different quantities, just display as one operation with the quanties rolled up.is that possible?

thanks.

souvida :us: (BOB member since 2004-05-10)

4

never mind,
i created another variable which would sum up the values for each operation name in that particular block… and now i am using that as my variable.
thanks.

souvida :us: (BOB member since 2004-05-10)