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)