Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Bubskim
Contributor II
Contributor II

combining values

please help me combine values. Attached is a mock excel. 

I would need to combine subject 1 and subject 2 in my graphs and charts. The same goes for say another subject 3 and subject 1.

 

thanks

2 Replies
Claudiu_Anghelescu
Specialist
Specialist

Dimension:

 

If(Subject<>'subject03', Subject)

or

If(Subject<>'subject02', Subject)

To help community find solutions, please don't forget to mark as correct.
Bubskim
Contributor II
Contributor II
Author

Hi. Nothing happened.

Can you translate what you wrote or what you are trying to type?

I would like two subjects combined as one. 

or

two email addresses truncated as one email