Need help with an exercise

[RaviPM10]

Hi Team, Can you please assist me with below exercise 

have following data, which is coming from data base as below 

Name	Market Value	Fund return	Fund BN Weight	Fund End weight	BM BGN Weight	BM END Weight
Domestic	100	2.32225	25	25	25	25
International	200	2.42123	25	25	25	25
World	200	3.146255	50	50	50	50
Total	500	2.0235	100	100	100	100

need output as below 

Name	Market Value	Fund return	Fund BN Weight	Fund End weight	BM BGN Weight	BM END Weight
Total	500	2.0235	100	100	100	100
Domestic	100
International	200
World	200

[cjaneczko · Accepted solution]

Use a Multi Field Formula and select all the numeric fields except Market Value. Then use the following:

if [Name] != 'Total' then null() else [_CurrentField_] endif

If you want the Total on top, put a sort tool after that and sort Market Value descending. 

[RaviPM10 · Accepted solution]

I tried but not getting desire output

[RaviPM10]

its working Thanks for your help

[cjaneczko]

Glad it worked.