i have a fruits and costs, i wanted to group by multiple fruits share accross other category - please find attached workbook
like below - Apple and banana are in group 1
Apple and Gova are in group 2
Apple and mongo are in group 3
orange and mongo are in group 4
grapes and mongos and apple are in group 5
if [Fruits] = 'Apple' or [Fruits] = 'banana' then "group1"
ELSEIF [Fruits] = 'Apple' or [Fruits] = 'Gova' then "group2"
ELSEIF [Fruits] = 'Apple' or [Fruits] = 'Mongo' then "group3"
A group should have unique values. Per the example above, Apples will always be in Group 1 because that's the first condition being checked. Not sure what you are really trying to do here.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...