Formatting report

I have a report that has three quantities Product Id , Quantity sold & type
here type has three vaues (low medium & high) so when I get the
flat report the report looks like this

Id, Quantity , Type ,
1 5 Med
1 4 High
1 7 Low
2 3 Med
2 5 High
2 4 Low
2 3 High

Etc Please Notice that under Id = 2 there are 2 entries for high Qty
now if I slice & dice this like

Id Vs Type/Quantity it is repeating Id values in the sliced table
instead of showing all quantity in one row it shows eachin 1 row
repeating Id & leaving other types blank

Eg

Type Med High Low
2 3
2 5
2 4
2 3

Now I want it to add up multiple values under high if they exist & display in the following format

Type Med High Low
2 3 8 4

Can any one help if you need clarification please let me know


DukeofPune (BOB member since 2004-07-15)

Make sure Quantity is defined as a measure using a SQL Group By function AND that the Projection is set to SUM (all done at the universe level).


Andreas :de: (BOB member since 2002-06-20)

Thanks Andreas It worked thanks for all the help


DukeofPune (BOB member since 2004-07-15)