How to show to values of one dimension as one on a graph

[paweln]

Let say I want to show Men's Clothes and Men's Footwear as "Men's Clothes and Footwear". Only for this graph. 

[lironbaram · Accepted solution]

hi 

if it's only for this chart you can do something like this in your dimension

if(wildmatch(Category, 'Men*Clothes*','Men*Foot*')>0,'Mens Clothes and Footwear',Category)

[Anil_Babu_Samineni · Accepted solution]

Perhaps this way IF you have only 2 values related Mens?

if(wildmatch(Category, 'Men*'),'Mens Clothes and Footwear',Category)