multiple rows to single record and total it

[satishsure]

Hi ,
I have requirement to create single row instead of multiple rows and need to make total of the measure value column and for brand column need to have data separated by coma.

ID                ||  Brand    ||    Gross Value
-------------------------------------------------------
B-0007742    ||     SW            ||    100,000
B-0007742    || POWER    ||     500,000

My new list  report should be like this

ID                ||  Brand                             ||    Gross Value
--------------------------------------------------------------------------
B-0007742    ||     SW   ,POWER        ||    600,000

Thanks for your help..Its really great help to resolve my issue. ;D ;D ;D

[Lynn]

Is your source relational or dimensional?

You can use a repeater for the brand and connect it to the list using a master-detail relationship. It isn't always the best performing option to use master-detail but it may work in your situation if volumes are not massive.

[satishsure]

Thanks for the reply,
Mine is relational, I am new to repeater..Is repeater should be used with new query or with in the existed query?
In master detail relational which field i need to connect with link, Is it brand-->brand ?
What about total of the gross value? will total comes automatically?

[Lynn]

You can use the same query if you like or you could have a separate one. I generally prefer to use the same query where possible.

I would assume your link should be on ID. The main list will then aggregate your gross value to the ID level, which is what you want. Then your repeater will return all the brands within that ID and arrange them as you want.

Sometimes you just need to play around and try things out to learn.