How can I create segments (in list boxes) that are subsets of each other? (i.e. overlapping data)

[Anonymous]

Hi everyone,

My raw data looks like this:

Age	Gender	KPI
20	F	100
20	M	200

I would like to create new categories and have them show up in list boxes on the side, such as 'Females 20-30'. However, I also want 'Adults 20-30'. I'm unable to do this through if statements because Females 20-30 is a subset of Adults 20-30. In other words, there's data overlap between the two segments. Is there a way to get around this?

Thanks,

Yefan

[Anil_Babu_Samineni]

There is no 30 age in ur sample data?

[Anonymous]

Yes, in my dataset there would be every variation of age and gender.

How would I be able to create a listbox of segments which sometimes overlap each other? Such as:

'Adults 20-30'

'Female 20-30'

'Female 20-25'

Thanks!