How to create group Articles for SubTotal

[#1]

Hi,

I have the fiels follows : Articles - UnderFamily - Family.

Example : CodeArticles(0000A)- CodeUnderFamily(AAAA)- CodeFamily(AAAAB)

I would like to get this results :

If I create field like : 'CodeArticles& ' ' &CodeUnderFamily& ' '&CodeFamily do I obtain the result like the picture ?

Thanks for your help.

[RSvebeck]

Hi.Perhaps this will help you. See attached. //Robert

[#3]

Thanks a lot . It try like that and it works very well !!

[#4]

Could I have an example with Switch case.

Example:

IF AAAA => GROUP 1

IF BBBB => GROUP 2

IF CCCC => GROUP 3

IF DDDD => GROUP 4

Thanks.

[RSvebeck]

Hi.

What is AAAA, BBBB, CCCC and DDDD?

Different Underfamilies?

//Robert

[#6]

Sorry,

AAAA, BBBB, CCCC and DDDD are the underFamilies.

Like:

CASE UnderFamilies

when 'AAAA' then 'GROUP1'

when 'BBBB' then 'GROUP1'

when 'CCCC' then 'GROUP2'

when 'DDDD' then 'GROUP2'

End

Thanks..

[RSvebeck]

Do you mean like this?

[#8]

Yes.. thanks.

It was just to have an example with switch case...

[RSvebeck]

Okay, if your questions now has been answered, please close the discussion as "Solved" so if someone in the future has a similar question they  will know that this thread was solved. //brg Robert