How to show category wise distribution.

[dhananjay_capge]

Test

[Anonymous]

Dhanunjay,Can you provide sample data??

[Kushal_Chawda]

=if(wildmatch(lower([Error Text]),'*you can''t use business partner*'),'Invalid Business Partner',

if(wildmatch(lower([Error Text]),'*owner is inactive*'),'Owner is Inactive',

if(wildmatch(lower([Error Text]),'*exception:*'),'Exception in c4c',

if(wildmatch(lower([Error Text]),'*please enter an existing product id*'),'Missing Technology')))) as Category

Edit: syntax error is corrected

[Anonymous]

Try this

if(WildMatch(Lower([Error Text]),'*business partner*'),'Invalid Business Partner',

if(WildMatch(Lower([Error Text]),'*Owner is Inactive*'),'Owner is Inactive',

if(WildMatch(lower([Error Text]),'*Exception:*'),'Exception in c4c',

if(WildMatch(Lower([Error Text]),'*Please enter an existing product ID*'),'Missing technology'))))

[sunny_talwar]

Jakhas