Hi,

I have a requirement where I need to show split up percentage(split up % column in the below example) for each row for a perticular filed.
For ex.

CAR COUNTRY MODEL SPLIT UP % RETAIL_COST
ALFA ROMEO ITALY 2000 4 DOOR BERLINA 30.30% 5,925
2000 GT VELOCE 34.85% 6,820
2000 SPIDER VELOCE 34.85% 6,820
Total 19,565
AUDI W GERMANY 100 LS 2 DOOR AUTO 100.00% 5,970
Total 5,970
BMW W GERMANY 2002 2 DOOR 10.11% 5,940
2002 2 DOOR AUTO 10.81% 6,355
3.0 SI 4 DOOR 23.40% 13,752
3.0 SI 4 DOOR AUTO 24.03% 14,123
530I 4 DOOR 15.48% 9,097
530I 4 DOOR AUTO 16.16% 9,495
Total 58,762


Could anyone help on this...

Thanks in Advance.



Wf 7.1 Excel

This message has been edited. Last edited by: Kerry,

TABLE FILE CAR
WRITE
PCT.RCOST/D6.2 WITHIN CAR
RCOST
BY CAR BY COUNTRY BY MODEL
END

quote:

TABLE FILE CAR
WRITE
PCT.RCOST/D6.2 WITHIN CAR
RCOST
BY CAR BY COUNTRY BY MODEL
END

Hi Jack Gross,

Thanku you very much for your reply, I got it,It helped me a lot.

Thanks Once again.

Sri
Wf 7.1 excel